SQLSTATE=S1000, DBMS.CODE=950088

[Lovesh_Patni]

Hi,

When I'm trying to access two hash files from universe stage i get below error.These two hash files are created under directory.I set these file paths,created and built indexes through ds adminstratior.
Please let me know how to fix this error?

GSO05_Occ_Investigation_FactLoad..UniVerse_39.DSLink40: DSD.BCIOpenR call to SQLExecDirect failed.
Statement was:SELECT A.OCC_NBR, B.OCC_DATE_ID, B.Risk_Code, B.VEH_EQUIP_DEPT_ID, B.OCC_EVENT_ID, A.WR_NBR, A.WR_PERIOD, A.WR_TYPE FROM hOCC_INVFACT_1 A
LEFT OUTER JOIN hOCC_FACT_1 B ON A.OCC_NBR=B.OCC_NBR
SQLSTATE=S1000, DBMS.CODE=950088
[DataStage][SQL Client][UNIVERSE]DataStage/SQL: syntax error. Unexpected literal string. Token was "
LEFT". Scanned command was FROM hOCC_INVFACT_1 A
LEFT

[ray.wurlod]

Put all mixed case column names in double quotes.

[Lovesh_Patni]

Hi Ray,

This is resolved now.

I tried placing quotes but it didn't work.Lastly I tried rewriting the same sql in one line and it worked.

Thanks.


Regards,
Kartheek