book
Article ID: KB0076407
calendar_today
Updated On:
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.
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
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.
https://www-01.ibm.com/support/docview.wss?uid=isg3T1026805
Please also check your ODBC setup/configuration:
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:
update "T60FILES"."VARCUST" set "RMADD1" = ?, "RMADD2" = ?,
"RMADD3" = ?, "RMCITY" = ?, "RMSTAT" = ?, "RMMZIP" = ?,
"RMMFON" = ?, "RMEMAL" = ?, "RMWURL" = ?
where "RMCUST" = 'W069089'
Using the wrong configuration may cause Scribe® to send an update statement looking like:
update "VARCUST" set "RMADD1" = ?, "RMADD2" = ?,
"RMADD3" = ?, "RMCITY" = ?, "RMSTAT" = ?, "RMMZIP" = ?,
"RMMFON" = ?, "RMEMAL" = ?, "RMWURL" = ?
where "RMCUST" = 'W069089'
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.