List available library - SQL Linked Server AS400

5
votes

I'm using SQL server 2005 (64bit version) and have successfully connect to as400 using IBM DB2 UDB for iSeries IBMDA400 OLE DB Provider. Anyone know how to list available library/table and get the field name & description?

already looking around, and have tried this query, but still no luck

select * from OpenQuery(AS400, 'select * from QSYS.qadbxatr');
1
sql-serveribm-midrange

1 Answers

8
votes

The information is available through the catalog views in the SYSIBM schema.

Schema (library) information is available in SQLSCHEMAS.

Table (file) information is available in SQLTABLES.

Column (field) information is available in SQLCOLUMNS.