In DataStage Designer, if the SQL statement contains a division operator in the Teradata connector, a 'missing from the schema' error occurs

Troubleshooting

Problem

In DataStage Designer v8.5, if the SQL statement contains a division operator (for example, A/B) that is used in the Teradata Connector, the job runs successfully. The workaround was not needed in v8.5. If the same division operator is used in the SQL statement within the Teradata connector is Designer v9.1, the job will fail causing an error similar to this to occur: Message: Teradata_Connector_130: Field TARGET/ORCHESTRATE.SOURCE is missing from the schema (CC_TeraDBRecordDataSetConsumer::setDataSetDef, file CC_TeraDBRecordDataSetConsumer.cpp, line 534)

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1.2.0;9.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Was this topic helpful?

Document Information

More support for:
IBM InfoSphere DataStage

Software version:
9.1.2.0, 9.1

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
241611

Modified date:
25 April 2025

UID

swg21667076

IBM Support

Tips