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
SQLSTATE=S1000, DBMS.CODE=950088
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 13
- Joined: Fri Jun 22, 2007 1:29 am
- Location: Perth
SQLSTATE=S1000, DBMS.CODE=950088
Lovesh Patni
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 13
- Joined: Fri Jun 22, 2007 1:29 am
- Location: Perth