Not able to see all the schema listed in the Object Explorer for iSeries (4251234)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Not able to see all the schema listed in the Object Explorer for iSeries
Description

When connected to an iSeries server, unable to see other schema in the Object Explorer, besides the one being connected to and maybe one or two other schema, and all their associated objects. However, tables in the schema that cannot be seen can have queries run on them with no problems, in the editor.
Resolution

There is a setting in the iSeries ODBC setup screen on the “Catalog” tab where the Library view can be set. The options are “Default Library List” or “All Libraries on the system”. Select “All Libraries on the system”.
Note:
If adding a library or changing the above setting, you may require that a new iSeries connection be created, in Toad, to reflect the changes made to the DSN

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title