passing parameters from table.

snt_ds · Post by **snt_ds** » Fri Apr 13, 2007 5:42 am

Hi guru's,

I have to pass set of parameter values to a job sequence from tables.I acheived it through writing to a file and the read it as parameter file.Is there any other way to perform this?Thanks.

DSguru2B · Post by **DSguru2B** » Fri Apr 13, 2007 7:05 am

What database is it?
With either oracle or db2 or even sybase for that matter, you can probably write a small routine that invokes command line sql using DSExecute(), queries the table and returns the value. What parameter value to get?, that could be decided with an input parameter that you send to the routine.
If you are doing well with pouring the parameters to a file and then using that, I say stick to it.

snt_ds · Post by **snt_ds** » Fri Apr 13, 2007 8:21 am

Dsguru thanks for your reply.Database is sybase.Can i call these routine using excecute command activity and parse command output values to the job parameters like reading from a parameter file?Could you plz share some sample code or link i can refer too?Thanks for your time.

DSguru2B · Post by **DSguru2B** » Fri Apr 13, 2007 8:32 am

If you were to run a sql command from unix command line, how would you do that for sybase?
Wrap that in DSExecute() and you have yourself a routine. Search the forum for specific examples of how to use DSExecute().