DSXchange

Hi

i wants to pass shell varible as datastage job parameter. please any body can help me.my DBA was aking me to pass shell variable as datastage job parameter insted of job level parameter


Thanks

Narsi

Hi Narsi,
Its possibile. But need more details. If you are calling a job using the shell (command line) using dsjob -run option you can pass the parameter to the job using -param option. And the value can be your shell variable. If you are some way referring to Environmental variable, again its possible. Search for $ENV you ll get to know.

Where is this shell variable present? Use a routine to invoke the file that sets this shell variable and within the same routine read the value using echo $SHELLVARIABLE. It will spit out the value. All this can be done using DSExecute() within a routine.