IBM Support

ODBC connector does not allow column names with spaces in user defined SQL statement (Columns are defined using brackets [])

Troubleshooting


Problem

ODBC connector results in error when trying to load columns which names use spaces. I.e. "Column name", "Second column". Use quoted identifiers option does not work either.

Symptom

Following errors in the job log:

Message: ODBC_Connector_57: External schema field, name: Column name, type: INT16 was not found in the design schema
Message: ODBC_Connector_57: When checking operator: The modify operator has a binding for the non-existent output
field "Columnname".


ODBC_Connector_57: Error when checking operator: Error creating schema ( record( Type:nullable string[max=1]; Column name:nullable int16; Date:nullable string[max=20]; Second column:nullable dfloat; ) ) from DataSetDef provided by connector: In field "Column": Expected ";", got: "name", line 1
In field "Second": Expected ";", got: "Column", line 1:

Syntax specified in user-defined SQL:

SELECT [Table name with spaces].[Column name]

, [Table name with spaces].Column1

,[Table name with spaces].Column2

, [Table name with spaces].[Second column];

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5","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.

Document Information

Modified date:
25 April 2025

UID

ibm10795278

Page Feedback