DSXchange

I am trying to access HF using UV Stage, but getting the following error. The metadata of UV is same as HF..just not sure what the problem is.


HFTesting..UniVerse_11.DSLink7: DSD.BCIOpenR call to SQLExecDirect failed.
Statement was:SELECT ID, DATE1, DATE2, DATA FROM HF_ACCT2
SQLSTATE=S1000, DBMS.CODE=950088
[DataStage][SQL Client][UNIVERSE]DataStage/SQL: syntax error. Unexpected symbol. Token was "DATA". Scanned command was FROM HF_ACCT2 SELECT ID , DATE1 , DATE2 , DATA


Thanks.

DATA is a reserved word. Put it in double quotes in the Derivation column.

Right on...Thanks Ray.