Page 1 of 3

Selective Command Line Export?

Posted: Tue Jan 31, 2006 8:49 am
by patonp
Although the dscmdexport command provides a means to export an entire project, I would like to selectively export components. Is there a facility within DataStage that will allow me to do this without using the GUI found in Manager?

Thanks!

Peter

Posted: Tue Jan 31, 2006 8:55 am
by chulett
Not that I am aware of. :cry:

Posted: Tue Jan 31, 2006 10:39 am
by kaps
DSExport command can also export individual jobs.

Thanks

Posted: Tue Jan 31, 2006 10:53 am
by kcbland
kaps wrote:DSExport command can also export individual jobs.

Thanks
Care to share the exact command line syntax for how you accomplished this?

Posted: Tue Jan 31, 2006 11:54 am
by kaps
Syntax is as follows:

DSExport /U=%UserName% /P=%Password% /H=%Host% /JOB=JobName %Project% FileName

Thanks

Posted: Tue Jan 31, 2006 7:20 pm
by jzparad
Very interesting.

I haven't found this documented anywhere but it works (on Windows anyway)!

Doesn't work for dscmdexport only dsexport.

Posted: Tue Jan 31, 2006 8:45 pm
by chulett
Windows as in on the client or a Windows Server install only?

Posted: Tue Jan 31, 2006 9:11 pm
by jzparad
DataStage 7.5 running on Windows!

And I'm running the client from a Windows machine as well (in fact the same machine).

Posted: Tue Jan 31, 2006 9:29 pm
by chulett
Looks like this is a Client command and may only work if the Server is running on the same machine. I'll have to experiment a little more with this from the office tomorrow. Too many other fish to fry tonight. :wink:

Posted: Tue Jan 31, 2006 9:45 pm
by jzparad
Please let us know how you go!

Posted: Tue Jan 31, 2006 11:14 pm
by kumar_s
HI,

Yes the same works in PX (Sever in Unix and Clinet in Wondows) as well :!:

-Kumar

Posted: Wed Feb 01, 2006 3:21 am
by Andal
This Command will work on windows Client. We dont require the Server to be installed. I am able to export the jobs from the server which is in different location.

The problem with this command is , if we used any shared conatiners in the job, then it will import the code for shared containers as well. But if we export from Manager we wont get this, unless we check it expicitly.

And we wont get the job executables if we export the jobs from command line.
Please refer Here for More Information.

Posted: Wed Feb 01, 2006 10:36 am
by kaps
This is client command. DataStage does not need to be on windows.
This works even if DataStage server is in unix. But we need to run this command from client machine.

Thanks

Posted: Thu Feb 02, 2006 10:05 am
by patonp
This command seems to work well for what I'm trying to accomplish. I do, however, have one more question...

Is there any way I can specify more than one job to be exported using this command? Ideally, I'd like to specify a few jobs to be exported into a single dsx file.

Thanks again,

Peter

Posted: Thu Feb 02, 2006 1:57 pm
by kaps
Using the same command answer is NO. but you can accomplish what you want with the help of small batch file.

Thanks