Selective Command Line Export?

patonp · Post by **patonp** » Tue Jan 31, 2006 8:49 am

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

chulett · Post by **chulett** » Tue Jan 31, 2006 8:55 am

Not that I am aware of.

kaps · Post by **kaps** » Tue Jan 31, 2006 10:39 am

DSExport command can also export individual jobs.

Thanks

kcbland · Post by **kcbland** » Tue Jan 31, 2006 10:53 am

kaps wrote:DSExport command can also export individual jobs.

Thanks

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

kaps · Post by **kaps** » Tue Jan 31, 2006 11:54 am

Syntax is as follows:

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

Thanks

jzparad · Post by **jzparad** » Tue Jan 31, 2006 7:20 pm

Very interesting.

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

Doesn't work for dscmdexport only dsexport.

chulett · Post by **chulett** » Tue Jan 31, 2006 8:45 pm

Windows as in on the client or a Windows Server install only?

jzparad · Post by **jzparad** » Tue Jan 31, 2006 9:11 pm

DataStage 7.5 running on Windows!

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

chulett · Post by **chulett** » Tue Jan 31, 2006 9:29 pm

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.

jzparad · Post by **jzparad** » Tue Jan 31, 2006 9:45 pm

Please let us know how you go!

kumar_s · Post by **kumar_s** » Tue Jan 31, 2006 11:14 pm

HI,

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

-Kumar

Andal · Post by **Andal** » Wed Feb 01, 2006 3:21 am

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.

kaps · Post by **kaps** » Wed Feb 01, 2006 10:36 am

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

patonp · Post by **patonp** » Thu Feb 02, 2006 10:05 am

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

kaps · Post by **kaps** » Thu Feb 02, 2006 1:57 pm

Using the same command answer is NO. but you can accomplish what you want with the help of small batch file.

Thanks