Command line export

[edwardlee]

Dear all,

I want to export serveral datastage jobs in one file with following commands in windows.

"C:\Program Files\Ascential\DataStage7.5.1\dsexport" /h=host /u=user /p=password /exec /append PROJECT /job=JobName1 export.dsx
"C:\Program Files\Ascential\DataStage7.5.1\dsexport" /h=host /u=user /p=password /exec /append PROJECT /job=JobName2 export.dsx

I found that the executable is included in the dsx file.
I have to use the /append parameter for appending the jobs in one file, but it must be used with /exec which used for export executable.
Can any one tell me how to change the command to export without executable?

Thank you very much!

[ray.wurlod]

Welcome aboard.

I don't believe it's possible. But you can always remove the executable from the export file afterwards.

[chulett]

Seems odd that you 'must include' an optional command line switch like /exec but it's been a long time since I've played with that. What happens when you leave it off?

[edwardlee]

Seems odd that you 'must include' an optional command line switch like /exec but it's been a long time since I've played with that. What happens when you leave it off?

If I remove the /exec then I cannot use /append. The second command would replace the previous dsx file.

[chulett]

That makes even less sense, what would one have to do with the other?

I'll have to play with it when I get a chance.

[edwardlee]

Thank you for all your reply.
I have write a dos batch file to export job by job and concat the file into one.

I have another problem, I can export one job now but how can I export just one table def? I have search around and find no place talking about export just one table def. Please help.

[ray.wurlod]

No facility exists for exporting a single table definition or a single routine or a single anything else.

I did once write a routinefor dumping a table definition into a number of formats, including XML.