Exporting from SQL to DB2

I'm trying to export a table from our deployment server running SQL 2000 to our enterprise iSeries running DB2. Has anyone ever done this before with success. Thanks in advance for you help.

John,

You can copy tables with R98403, from Data Source xx to
Data Source yy. It will handle all of data conversion,
EBCDIC, ASCII, Date and Decimal format technostuff.

I have sometimes had problems with the Peoplesoft data transfer application. Another way to do this is to go to Enterprise Manager in SQL and go to your DB and right click TABLES and select ALL TASKS and then EXPORT DATA. This will bring up the Data Transfer Wizard that will you walk you through the process.

Miller,

If both files are OCM'd - you can use a table conversion to complete the task. TC is probably the most-simple way to make it happen.

(db)