I am generally familiar with DB2/400 and MS SQL 2000, but I am now trying to get DB2 UDB V8.1 Personal Edition working on a WINTEL development laptop.
I am currently using SQL DTS to transfer DB2/400 tables from AS400, transfer them to SQL 2000, and then transfer them to DB2 UDB on a WINTEL laptop. My problem is with the table creation on DB2 UDB. It is being built with my username which changes the SQL for data manipulation.
So, my questions are:
1) What is the DBO equivalent for DB2UDB so I can avoid creating with a username prefix?
2) And, is there something built into the DB2 UDB Personal addition that can transfer data directly from DB2/400 to DB2 UDB rather than going through SQL?