Datastage Export from Commandline
Posted: Thu Jan 08, 2009 2:04 am
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
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