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
How to get the Value in the Table to pass as parameter
Moderators: chulett, rschirm, roy
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers