How to get the Value in the Table to pass as parameter

Narayana · Post by **Narayana** » Sat Jun 14, 2008 2:45 am

Hi,

I have to capture a value in the table with 3 coluomns and pass the max value as parameter.

Can you please tell me how to proceed.

Thanks

ag_ram · Post by **ag_ram** » Sat Jun 14, 2008 5:33 am

Let getting the maximum value from the table be in the first Job and USERSTATUS will be useful in passing that value to next Job as Job parameter.

Searching "UserStatus" will give you more ideas of it.

chulett · Post by **chulett** » Sat Jun 14, 2008 6:52 am

Or land the value and then cat it into the Initial Value of a stage variable. Depends on where you need to use it in your job, it will need to be a job parameter to use in source SQL but a stage variable can be used without needing a Sequence (or other job control) to arrange the passing of same.

Narayana · Post by **Narayana** » Mon Jun 16, 2008 3:20 am

Can you tell me how to cat the value to the paramter value

Narayana · Post by **Narayana** » Mon Jun 16, 2008 3:22 am

Hi Chulett,

Can you tell me how to cat the value to the Stage Variable

regards,

chulett · Post by **chulett** » Mon Jun 16, 2008 6:46 am

You'd need a routine to execute the UNIX 'cat' command and pass back the result. You would call it in the Initial Value field of the stage variable. Now, Server forum so Server answer. Someone else would have to note exactly how one would do this in a PX transformer.