I am trying to export data from a database in MS-SQL server and import the same to a database in DB2 UDb v7.2 on AIX5. While trying to do this, I am getting some errors "table name is undefined" and "drivers are not capable."
I selected the IBM DB2 ODBC DRIVER for the destination server. Am I doing any mistake....
This is being posted in both DB2 and MS-SQL sites.
I am using the DTS Import/Export Wizard from SQL Server Enterprise Manger. From this I am selecting the source as SQL db and destination with IBM Db2 ODBC Drivers-DB2database. Here, the table is being created with the same columns in the destination database but no data being transfered.
What is the right way to transfer data from one db to another kind of db (in this case from MS SQL to DB2UDB) ?
Originally posted by Brett Kaiser
Some code woul;d help...
Can you select from the DB2 Table in SQL?
Also, I woiuld disagree with this statement...
What for example would you do with DB2's DATE or TIME Datatype?