database conversion

[slimmer]

Is it possible to update a DB2 table on the mainframe from MS Access? The data source will be coming from Sybase and the eventual target is DB2.

Is it possible to use Access to create the same table structures, connect to sybase and populate the data and then connect to db2 to populate with the data in Access?

We are experiencing many problems creating an extract file and loading it in DB2.

Any help is appreciated.

 

[MarcLodge]

Hi Slimmer,
I've updated DB2 tables from within MS Access via ODBC, so it certainly can be done. I seem to recall that we had a fair deal of trouble setting up the ODBC driver and the correct SQL/RACF groups.

Have a word with your DBA and security people to see if this is an option, and get back to us if you need more help.

BTW, what are you using to load the extract file, and what sort of problems are you having?

Marc