Assigning value to job paramerter in job

skaruturi · Post by **skaruturi** » Wed Sep 13, 2006 5:40 am

we want to assign a value to job parameter.The parameter has to take max value of a key column so that we use this job parameter to used as stat value in serrogate key generator stage

Kirtikumar · Post by **Kirtikumar** » Wed Sep 13, 2006 5:56 am

There are various ways to do this.

The one which we have used is - We have created on more job. This job gets the maximum value of the ID column from table. Then in from this job we call other job using DSJOB command from this job.
This was done in server.

One more way to do this is call the job from script. The script can extract the maximum value and then pass this value as param value in the DSJOB command.

skaruturi · Post by **skaruturi** » Wed Sep 13, 2006 6:45 am

Hi Karthik,

can the same approach be used for parallel job

Thanks,
Karuturi

keshav0307 · Post by **keshav0307** » Wed Sep 13, 2006 7:56 am

Create a routine to Read the maximum value from the table, and then call this routine in User variable Activity stage, and assign the return value to the parameter.

kool78 · Post by **kool78** » Wed Sep 13, 2006 10:31 am

keshav0307 wrote:Create a routine to Read the maximum value from the table, and then call this routine in User variable Activity stage, and assign the return value to the parameter.

As Keshava said,

U can also write the max value into a sequential file and then read that value(by calling basic routine) using user variables activity in sequence. and assign the output of the uservariable avtivity to your job parameter.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 13, 2006 2:35 pm

Always Routines!!!

Create a server job to get the maximum value (no point creating a parallel job to process one row). Have this job put the value into its user status area. Use the $UserStatus activity variable to supply the parameter value.

Have you thought through the appropriate mechanism for generating a sequence of unique numbers when executing in parallel mode?

kool78 · Post by **kool78** » Thu Sep 14, 2006 9:16 am

ray.wurlod wrote:Always Routines!!!

Create a server job to get the maximum value (no point creating a parallel job to process one row). Have this job put the value into its user status area. Use the $UserStatus a ...

HI ray..

a small request , can you please post the premium content for this post.

Thanks

ray.wurlod · Post by **ray.wurlod** » Thu Sep 14, 2006 2:49 pm

This site uses the "premium poster" concept as a means for funding the site. The revenue comes nowhere near paying for the site, but it helps.

The added value provided by these few posters ought to make it worth your while to invest the less than $1 per week required for a premium membership.

It is not appropriate for me - or anyone else - to accede to your request.