DSXchange

This script is not there

Its unnecessary causing huge file size for me for version control. Also the time taken for this activity is very much

I have already seen these scripts . ( excellent tips there) they are posted in some other threads as well

But they dont have the options to export without executables

I am looking for a client based solution, but it would be beneficial if you let me know both the options dsexport is a programme present in the installation directory so we were able to execute it. What programme is executed for istool , since i am unable to find any programme like istool.exe I am a...

Strange!!! whatever we can do with mouse ( running, exporting, compiling, etc ) should be achievable through the command prompt as well. Any workaround to achieve this will be appreciated !!! Literature says that istool commands are executed on CLI console!! where in DS I can execute these commands!...

dsexport.exe /D=domain:port /H=Host server /U=username /P=password /JOB=job name <Projectname> <Destination dsx file>

This way i am getting Job executables as well which i need to avoid. Is there any option to do so ?
EXEC option will give only executables.

Hi, Is it possible to export just the job design without executables from Command line using dsexport or dscmdexport command. This option is present in Designer , but whats the corresponding way to achieve the same through command line If its possible, please let me know the correct way to do so Tha...

Although the script will always return a non zero value on unsuccessfull execution, I will try to explicitly return non zero exit status after each statement in script. But it seems to be a lengthy solution.

shorter solution is welcome

How you calling that script from the routine? Capturing ScreenIO returning Errorcode should give you output in variable ScreenIO and the return code in ErrorCode. EDIT: if errorcode is not zero, the job will abort. I am calling the script by using Afetr Job subroutine (ExecSH) option in Job propert...

If the after-job script returns an error code then the job's status is set to aborted. ... My script is running db2 statements to insert records into table. One of the insert statement did not executed correctly. Although i am able to see the output of the script in the Dsta Stage director log, but...

Hi All,

I am calling a Unix script in the After job Sub routine of my data stage job.
Is there anyway i can capture the output returned from the script and abort the job and send a notification, in case the script did not executed correctly. ( return non zero outout)

Thanks in advance,
Punit

Hi, There is a requirement in our project to access DB2 ver 9.5 installed on z/OS systems . Since the Database Partitioning Feature (DPF) is a feature of DB2 Enterprise Edition and DB2 on z/OS does not support DPF feature, which we intend to use, Can DataStage be used to access DB2 on z/OS ? Thanks ...

Hi, I have a requirement of selecting the records from the source filtering on timestamp value Currently this timestamp value comes from the system table of the underlying database in the aftersql of my Db2 stage.But as the DataStage and the DB2 database are in two seperate servers, there is a diffe...

Please let me know how to turn off the operator as i am not able to fine it as an env variable in DS Administrator

The problem is not solved if i use the way suggested.

It is the following error when i try to view data in the Target Seq file

<APT_CombinedOperatorController,0> Operator terminated abnormally: runLocally did not return APT_StatusOk