Page 1 of 1

Command Line - Paramenters

Posted: Tue Jul 29, 2008 7:31 am
by nishtala
Hi Gurus,

We have paramenter sets defined for a datastage job which does a generic CDC, we pass parameters of table names and connetions and all that good information. From datastage when we run we select the parameter to be passed and run.

Now we have to do it autosys so we need a command line syntax which we are not able to find in documentation.

Can we pass parameter set values as paramenters to run a job through command. If any one have done it before please let us know the syntax.

Thanks in advance

Posted: Tue Jul 29, 2008 7:55 am
by VCInDSX
An interesting blog on Parameter sets can be found in http://it.toolbox.com/blogs/infosphere/ ... sets-25604 (Thanks to Vincent for his wonderful work).

Are you looking for syntax to pass specific parameters or the parameter set as a whole from a file?

Posted: Tue Jul 29, 2008 7:56 am
by VCInDSX
An interesting blog on Parameter sets can be found in http://it.toolbox.com/blogs/infosphere/ ... sets-25604 (Thanks to Vincent for his wonderful work).

Are you looking for syntax to pass specific parameters or the parameter set as a whole from a file?

Posted: Tue Jul 29, 2008 7:57 am
by chulett
The Command Line Interface is fully documented in either the Parallel Job Advanced Developer's Guide or the Server Job Developer's Guide. Or search the forums for 'dsjob'.

Posted: Tue Jul 29, 2008 10:56 am
by nishtala
I am looking to command line which will pass the parameter set a set of values and use the generic job and after it finishes use another paramenter set values for to run the same job.

It will be great if you can give me a syntax to use.

Thanks

Posted: Tue Jul 29, 2008 1:44 pm
by VCInDSX
Hi
Please check the section "Command Line Interface" in the Server Job Developer's guide (Page number 397 and later) for a detailed review of Command Line Invocation.

Section "Starting a Job" lists the syntax and options..

Try it out and post your respones here...

At a high level, you should be able to get a job running with the following template...

dsjob -domain domain_name -user userid -password password -server server_name -run -param ParameterSet.Param1=value -wait -jobstatus ProjectName JobName.invocationID

But there are a lot of variations that you can try.... and others can pitch in when you post your specific responses....

Good luck,

Posted: Tue Jul 29, 2008 2:01 pm
by nishtala
We will try this option and let you know if it works... Thanks for your responses

Posted: Tue Jul 29, 2008 2:05 pm
by nishtala
" param ParameterSet.Param1= value " part did the trick, it works.

Thanks a lot