retain duplicates out of hash file

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

DSbox61
Premium Member
Premium Member
Posts: 62
Joined: Mon May 22, 2006 10:18 am

Post by DSbox61 »

Thanks, Craig. I have a pathed hashed file. i also got the setfile syntax from the search in the forum.

setfile /dswork/ECOMS/output/interface/rti hf_rtid OVERWRITING

here, i have given the path, the name of the hashed file and overwrite syntax.

when i try to run this on unix, it says "Unable to open VOC file."

should i run this command in DS Administrator? i don't have access to Administrator.

Is there anyway i can run this command in UNIX?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

From UNIX you can start a TCL session using 'dssh', then LOGTO your project and then issue that command. Start it either in the DSEngine directory or your target Project directory, for the latter you can skip the LOGTO. Then do the SETFILE.

And note the VOC record must be the full path to the hashed file including the name of the hashed file. Then the 'handle' assigned (what you have as 'hf_rtid') can be anything but people typically repeat the hashed file name as it's less confusing:

Code: Select all

SETFILE /dswork/ECOMS/output/interface/rti/hf_rtid hf_rtid OVERWRITING
I've actually never run it from the command line like you did, perhaps correcting the syntax will allow it to run there as well.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply