DSXchange

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

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.

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

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.

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?