routine for control table/hash file it has read from

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
ravindrag
Participant
Posts: 40
Joined: Wed Dec 14, 2005 3:22 am

routine for control table/hash file it has read from

Post by ravindrag »

hi
all
i have one issue on

routine for control table/hash file it has read from

A routine that will read a control table/hash file and get a column value. Use that value as datastage job name and 'Run' that job, automatically.

thanks in advance
balajisr
Charter Member
Charter Member
Posts: 785
Joined: Thu Jul 28, 2005 8:58 am

Re: routine for control table/hash file it has read from

Post by balajisr »

ravindrag wrote:hi
all
i have one issue on

routine for control table/hash file it has read from

A routine that will read a control table/hash file and get a column value. Use that value as datastage job name and 'Run' that job, automatically.

thanks in advance
Can you please post the issue or error message you have received.
ravindrag
Participant
Posts: 40
Joined: Wed Dec 14, 2005 3:22 am

Re: routine for control table/hash file it has read from

Post by ravindrag »

all
i have one issue on

routine for control table/hash file it has read from

A routine that will read a control table/hash file and get a column value. Use that value as datastage job name and 'Run' that job, automatically.


i dont know how to write basic code for that plz some one help me this isuue

thanks in advance
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Before someone is going to write some custom code for you, could you please post your hashed file layout, particularly which column you are interested in.

You can write a custom routine which is passed the hashed file name, key value and column number which contains the value you wish returned. This routine is called from a routine activity in a Job Sequence and the return value is used to call a job. The process is not too complex. But do bear in mind that this forum is here to help people do their work and offer assistance and mutual help.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I'm not against reinventing the wheel (actually that's not true), but it's best if you have some experience before you do that, otherwise you'll end up with a triangular shaped rock.

Have you looked at the SDK routines UtilityHashLookup and UtilityRunJob?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply