TIBCO Scribe® ERROR: [HY000] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL5001
book
Article ID: KB0076407
calendar_today
Updated On:
Products
Versions
TIBCO Cloud Integration - Connect ( Scribe )
-
Description
The below is an IBM error being reported through TIBCO Scribe® Online:
ERROR [HY000] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL5001 - Column qualifier or table "NAME" undefined.
Environment
TIBCO Scribe® Online
Resolution
Per IBM Support:
The V6R1 IBM i Access for Windows client is not supported. Please use the V7R1 IBM i Access for Windows client with the latest service pack OR better use the IBM i Access Client Solutions - Windows Application Package.
In the ODBC DSN being used please ensure you are not using the default for Default Collection (Library) to QGPL. Please use the default library T60Files instead.
Without changing this the ODBC setup/configuration, AS400 is expecting an update statement from Scribe® to look like:
By adjusting the ODBC default library setting, it should allow for either of the above statements to work.
If you continue to have problems please reach out to TIBCO Scribe® Support. Support may ask you to contact IBM.
Issue/Introduction
ERROR [HY000] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL5001 - Column qualifier or table "NAME" undefined.
Scribe® Error being reported by IBM for using unsupported version of IBM client or ODBC setup/configuration