Search found 2 matches
- Thu Jan 15, 2004 9:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: File upload through DS
- Replies: 7
- Views: 2728
Thank you very much for your response!!! That was my original intent - I was going to use bcp on SQL side and LOAD on db2 side to transfer files. The problem is that DB2 does not support some of the SQL data types (smalldate) and these have to be converted on a fly. Actually, we migrating the data w...
- Thu Jan 15, 2004 7:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: File upload through DS
- Replies: 7
- Views: 2728
File upload through DS
Hello all, I have a task to convert databases from SQL to DB2. There are over 150 tables we need to upload (will be more in a future). Is it possible to use DS to do the work? We have created a job with ODBC connection to SQL Server and linked it to UDBLoad plug-in for uploading files to DB2. Works ...