All geek questions in one place

List of Available Libraries - SQL Linked Server AS400

I am using SQL Server 2005 (64-bit) and successfully connecting to as400 using IBM DB2 UDB for the ODE DB provider for iSeries IBMDA400. Does anyone know how to display an available library / table and get the name and description of the field?

already looking around and tried this request, but still no luck

select * from OpenQuery(AS400, 'select * from QSYS.qadbxatr');
+4
source share
1 answer

Information is available through catalog views in the SYSIBM schema .

Schema (library) information is available in SQLSCHEMAS .

Information about the table (file) is available in SQLTABLES .

Information about the column (field) is available in SQLCOLUMNS .

+7
source

Source: https://habr.com/ru/post/1490623/

More articles:


All Articles