Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

SQL5016 - Qualified Object Name Not Valid

Symptoms

During the export process from DB2 database in you can see error “Failed (93 msec) [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL5016 - Qualified object name [Object_Name] not valid.” or “SQL5001 - Column qualifier or table &2 undefined”.

Cause

The case is connected with the naming conventions in DB2 ODBC Driver Settings. In DB2 UDB for iSeries you can use either the system (*SYS) or the SQL (*SQL) naming conventions.

System naming (*SYS)

In the system naming convention, tables and other SQL objects in an SQL statement are qualified by schema name in the form:

 schema/table

SQL naming (*SQL)

In the SQL naming convention, tables and other SQL objects in an SQL statement are qualified by schema name in the form:

 schema.table

Solution

To solve this case please go to the ODBC Data Source Administrator and edit your DB2 ODBC Connection. On the ODBC Driver settings please go to the “Server” tab and change the value in “Naming Convention” option. Like it is shown on the screenshot:


If you will have some additional questions or face with some difficulties please contact our support team and provide detailed description of the case you faced with: support@ispirer.com


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

sqlways/troubleshooting-guide/db2/export-conversion/data/object-name-not-valid.txt · Last modified: May 07, 2018, 03:15:34 PM (external edit)
 
© 1999-2020, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement