Reading Column names with spaces in between
Posted: Wed Oct 21, 2009 7:47 am
Hi,
I am trying to read data from a table which has column names defined as [Original Cost] on a source system. I am using an ODBC Connector Stage to write a select query like 'Select A."Original Cost" as Original_Cost from A". But I am getting an error for incorrect syntax.
How can we write a SQL Select query in datastage to read this column?
I am trying to read data from a table which has column names defined as [Original Cost] on a source system. I am using an ODBC Connector Stage to write a select query like 'Select A."Original Cost" as Original_Cost from A". But I am getting an error for incorrect syntax.
How can we write a SQL Select query in datastage to read this column?