By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

Does DB2 support schema acquirement automatically

P: 1
Hi,

I am new user of DB2.
I would like to see whether DB2 can automatically acquire schema information of other data.
E.g., automatically get the table definitions in an Access database .
Thanks.
Hannah
Sep 19 '07 #1
Share this Question
Share on Google+
1 Reply


docdiesel
Expert 100+
P: 297
Hi Hannah,

just to avoid misunderstandings, please explain what you do need this for. What are you planning to do?

If my guess is right and you want DB2 to import an access.mdb easily, the answer is "no, DB2 can't". But there are ways. If you need to transfer data from M$-Access to DB2, a possible way to do is to access the DB2 database via ODBC, link its tables in the .MDB and to copy the data by "insert into ... select from...".

Regards, Bernd
Sep 20 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.