Read Hashed File with concatenated key

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

Post Reply
jdulaney
Charter Member
Charter Member
Posts: 13
Joined: Thu Feb 02, 2006 1:32 pm

Read Hashed File with concatenated key

Post by jdulaney »

I am trying to develop a routine that reads a hashed file with 3 key fields and returns the value in the 4th field. I am using READU to read the file, but the read fails, because I obviously don't know the syntax to pass it the concatenated key. Can anyone help?
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

There is a @TM between key fields. So

Key1 :@TM: Key2 :@TM: Key3

I what you need.
Mamu Kim
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

By the way use READ if you do not plan to WRITE to the file otherwise you will leave locked records behind unless you use a RELEASE.
Mamu Kim
jdulaney
Charter Member
Charter Member
Posts: 13
Joined: Thu Feb 02, 2006 1:32 pm

Post by jdulaney »

Thanks, Kim....

I knew it had to be something simple, but impossible to find in the documentation!

Jeanne
gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

Re: Read Hashed File with concatenated key

Post by gateleys »

Just what you need. You will have to extend the 2 columns key to 3 columns.

viewtopic.php?t=86581&highlight=read+hash+file+routine

gateleys
Post Reply