TTBOMK SQL tables may easily be converted into CSV files, or even spreadsheets. From there it is a simple matter of using the CA upload facility. The other alternative is to FTP the data into a similarly predefined DB2 table. Dave
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
convert SQL table to DB2
Collapse
X
-
convert SQL table to DB2
You can use the BCP.EXE utility within Sequel Server to perform a bulk copy out of the SQL tables into a csv or tab delimited file, then upload it as David mentioned using iSeries Access. If you want an interactive option to extract data through an "ODBC" type connection, look for something called DRDA which is IBM Dynamic Remote Data Access tool. I believe you will find it within their Data Propagator, or DB2 Connect products. If you install that on your PC server, the iSeries can send SQL statements to it. Good luck!
-
convert SQL table to DB2
You could also do a JDBC connection. (Yes Java). Search the net for some sample code. Also this would allow you to connect to other sources (assuming you have a JDBC driver for the database) ... or this...?? http://www.mcpressonline.com/mc/.6b2030a3!more=1#more
Comment
Comment