DSXchange

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.

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.