running unix script from a job

[RAJARP]

Hi,
I am having a shell script which gets max(emp_id) from database(oracle) and writes that value into a sequential file.
Now I want to design a job which would run the shell script first and then extract the max(emp_id) from sequential file and that max(emp_id) should be set as job paramater.please help me.thanks in advance,
Regards,
rajarp

[ray.wurlod]

No you don't. You want to design a job sequence that does this.

This is because a job can not legally change its own parameter values.

[satadru.kar]

the other way arround to build a custom Stage, where you can spacify your unix script...

[Minhajuddin]

I can see two ways of doing this: (Both use a *job sequence*)

Write a basic routine which reads the contents of a file and puts the value in a User variable activity or a routine activity and then passes the value stored retrieved in the file to a downstream job.

Use the above logic. But, instead of a basic routine use a unix command and instead of a user variable activity use an Execute command activity.

The last is a bonus one (Works only with server)

You can store the value which you want to pass as a job parameter in the *User status* of a job and then pass it to a downstream job.

[RAJARP]

I can see two ways of doing this: (Both use a *job sequence*)

Write a basic routine which reads the contents of a file and puts the value in a User variable activity or a routine activity and then passes the value stored retrieved in the file to a downstream job.

Use the above logic. But, instead of a basic routine use a unix command and instead of a user variable activity use an Execute command activity.

The last is a bonus one (Works only with server)

You can store the value which you want to pass as a job parameter in the *User status* of a job and then pass it to a downstream job.

hi Minhajuddin and all,
thank you very much for ur patience.but i want to know how to write a routine which will get value from a sequential file and how can i set these extracted value as job parameter.can u please provide me with some sample routines r links from where i can get sample routines.i have searched various sites and forums.but i dint get any.please help me.
thanks in advance,

regards,
rajarp

[chulett]

You don't need a routine. Use an Execute Command stage to 'type' the sequential file and capture the $CommandOutput, using it as a parameter in a downstream job.