In ODBC_Connector under "SQL" --> "Select statement" I have a SQL statement that references a column name that contains a question mark in the name.
Example:
select
[NM Study?] as nm_study
from dbo.view_study
Looks like DataStage is replacing the "?" with the word "null" and so returns an error saying 'Invalid column name "NM Studynull"'.
(Note: I am connecting to MS SQL Server via the ODBC_Connector)
Below is the exact error message when I try to "View data":
ODBC function "SQLNumResultCols" reported" SQLSTATE = 42522: Native Error Code = 207:Msg=[IBM(DataDirect OEM)][ODBCSQL Server Wire Protocol driver][Microsoft SQL Server] Invalid column name "NM Studynull"
ODBC_Connector: column name with question mark in the name
Moderators: chulett, rschirm, roy