Datastage Export from Commandline

[Leonie]

Hi all

I'm using the commandline utility to automate our Datastage exports.
I have schedule the batch job to run everyday but I have encountered the following problems

Command

C:\IBM\InformationServer\Clients\Classic\dscmdexport /H=hostname /U=user /P=passw /O=omitflag project1 c:\DSExports\Production\%date:~0,4%%date:~5,2%%date:~8,2%\project1.dsx /V

This part writes it to a different directory everyday (generates todays date)
%date:~0,4%%date:~5,2%%date:~8,2%

1) A window pops up to overwrite the file - the file doesn't exist but even if it does - I don't want the Popup window. Is there an extra switch that I need to add to the command to overwrite the file?

2) The export runs fine until it gets to the Data Quality Specifications
See Error blow (This is one of many lines)

Could not get object 'JPNAME.DCT' from Repository/Data Quality Specifications (Error compiling query)

I get the error in the log only if I kill/disconnect the connection of the Export - the export freeze/hangs at this part.

Is there a way to skip the Data Quality Specifications in the export or is how do I fix this?

Many Thanks

Leonie

[Leonie]

Hi

I manage to get this to work on an other server - same command - just different client.
I did that Yesterday - today it doesn't work I get the following.
Same command same client but this error.

Attaching to 'project1' ...
dscmdexport aborted:
Failed to attach to the project

This is really frustrating!
Is there any other way of automating exports?

Many Thanks
Leonie

[chulett]

1) A window pops up to overwrite the file - the file doesn't exist but even if it does - I don't want the Popup window. Is there an extra switch that I need to add to the command to overwrite the file?

This happens when your default (i.e. the last one performed) component export file type is set to 'XML' in the Manager. Switch it to 'DSX' instead and that behaviour will stop.

[Leonie]

This is on the commandline and as far as I know you cannot export to XML on the commandline - it is always DSX.

Manager - in Enterprise there is no manager?

[ray.wurlod]

In version 8 exports are done from the Designer, since there is no longer any Manager client. What Craig asserts is true for exports done from Designer.

[chulett]

Sorry, missed the 8.x tag.

[jusami25]

Hi all,

we are having the same issue. WE want to find a way of create an export by using our automated command line script without including these Data Quallity specs. they are causing the export program to abort.

Any clue about that??


Thanks
Julio

[mandyli]

Hi


I am also trying via Unix level and windows level.

Is there any way to export folder wise instead of whole project.


Thanks
Man

[ray.wurlod]

None of the above seems to be related to the Information Analyzer product. Have I missed something?