Previous Topic

Next Topic

Book Contents

Book Index

Error SQL5016 with DB2 for iSeries

While trying to display the Database Explorer window, you may get an such as:

S1000(-5016)[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL5016 - QUALIFIED OBJECT NAME xxxxx NOT VALID

The error is happening because your database connection is defined to use the *SYS naming convention and this is not compatible with the queries AQT uses to display the information in the Database Explorer window.

There are two options for you:

You can get the same error message if you are running a query and your query is using the incorrect naming convention. In this case you need to either amend your query to use the correct naming convention, or change your ODBC Datasource configuration as described above.