Not able to see list of tables in AS/400 (iSeries)

Q: What if I cannot see a list of tables with AS/400 iSeries Driver connection?

A: With connection to an iSeries driver via ODBC….

- In the ODBC Administrator … choose to modify the DSN.
- Under the 'Catalog' tab of the 'iSeries access for Windows ODBC setup' dialog ... there is a setting called 'Enable search patterns'
If this setting is not checked then the tables will not be visible in the 'Databases and Tables' list in dQuery.
If this setting is checked (enabled) then you should see the tables.

©2004 dataBased Intelligence, Inc., dQuery and dBASE are trademarks of dataBased Intelligence, Inc. /  All rights reserved. All other copyrights and trademarks are the property of their respective copyright or trademark holder       FAQs