Hi all,
In past I have used SQL queries on the Hashed file using Command Line ( either in Administrator or on Unix ) but at that time the Hashed files were Located in the Default project directory.
Now when the Hash files are getting created in a separate directory other than the Default project directory then I am not able to run any of these queries. Do I need to set some Enironment variable which can point to my Hashed Files directory.
I have even tried to enable the dssh for the directory where my Hashed files are getting created but still I am not able to run any of these queries.
Can someone please help me on this ?
TIA
dsusr
How to Run a Query on Hashed Files using Command Line
Moderators: chulett, rschirm, roy
You would need to create a VOC record for each of these hashed files, that is what is missing when you don't create them in an 'account'. Plenty of discussion here on the subject, but here's some quick syntax:
The <name> would be what you would reference in your SQL and would typically be the name of the hashed file itself, but can be anything. Oh, and the 'full' path includes the name portion as well.
Code: Select all
SETFILE <full hashed path> <name> OVERWRITTING
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Avoid using the optional OVERWRITING keyword - it can cause you silently to trash important words in the DataStage vocabulary, a situation that is incrediby difficult to diagnose.
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.