How to query link database to as400
Posted on 2006-10-20
I have a link database to as400 through system ODBC.
How can I query a table on the as400, assuming the link name is "as400", library name is "test", table name is "table".
I found some articles here that suggests two syntax:
select * from as400.library.owner.table
select * from as400.library.schema.table
Which one should I use? The first one doesn't work with me. And I don't know what is the schema for the as400 database if I use the second one.
Can someone give me a hand?
Thanks a lot.