title: List available library - SQL Linked Server AS400
body: <p>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 &amp; description?</p>
  
  <p>already looking around, and have tried this query, but still no luck</p>
  
  <pre><code>select * from OpenQuery(AS400, 'select * from QSYS.qadbxatr');
  </code></pre>