Datastage Routine HashLookup

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
parsi_cnu
Charter Member
Charter Member
Posts: 43
Joined: Thu Dec 04, 2003 4:26 pm

Datastage Routine HashLookup

Post by parsi_cnu »

Hi Everybody,
I am getting last run date from the job and using that parameter for the current job to get only refershed data. I am using HashLookup Routine anda given the hashfilename, lookup column and position .
It worked fine in my Test env in DSManager but when i ran the same routine to excute in DSSequencer it is giving error.

How should i pass the parameter in single quotes or double quotes.

Thanks in advance
parsi
jmorgan
Participant
Posts: 10
Joined: Thu Mar 10, 2005 7:29 pm
Location: Brisbane, Australia

Post by jmorgan »

It depends on which version of DataStage exactly.

Prior to 7.5 (I note you are on 6.x) you can only pass one of the job sequence's own parameters (the definition of which is slightly extended to include results from prior activities in the sequence) or a literal string (double or single quotes are ok).

In 7.5 you can generate the parameter value using a valid expression.
Post Reply