Hi,
I am trying to join 2 hash files in a universe when i try to view data in universe, it's throwing below error
'SQLSTATE=S0002, DBMS.CODE=950390
[DataStage][SQL Client][UNIVERSE]DataStage/SQL: Table "hOCC_INVFACT_1" does not exist.
I understand that need to set the pointer but i don't know the syntax and where i need to specify. Can anyone assist me.
Universe error
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You don't necessarily need to set a pointer; the pathname of the hashed file will suffice, depending on the option chosen in the Hashed File stage. The error, by the way, is not in UniVerse, it's in your design - you have not properly specified the location of the hashed file. If you believe you need to use a VOC pointer, search DSXchange for the SETFILE command.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.