DSXchange

itis oracle database.

2 new fields are added to oracle table.to populate this I need to execute a sql which willbe using 2 tables and if itsatisfies the criteria of the sqli i need to populate the field with yes. for the 2nd field i have a different sql which i need to execute and then populate that with yes. can you ple...

I have to run 2 jobs parallely and if both of them are ok I need to do the 3rd job, how can i design it and how do i check the status of the first 2 jobs.
this is on windows.Everthing has to be scheduled to run.

you have the trigger option where you can specify that if the job is successful ( status = 0 that is ok) then do the next job, if the status is not ok then you do a different job as per your choice.

please execute the script outside datastage first and check if it is working.
then what ever command you gave to execute, the same thing should be given from datastage.

thanks a lot kduke , it works fine.
thanks to others also who offered help

the first dsjob command is ok problem with the second one only

when I compile and execute it the first resetting part gets executed but after that its giving the same error

./rama1.sh: !/bin/ksh: not found
Error running job

Status code = -2 DSJE_BADSTATE
Status code = -9999 DSJE_DSJOB_ERROR

when i run it from designer it is perfect, problem only with the script, the job name is pa1 and the project is MANC

i left the last line it is
-warn 10000 MANC pa1

/bin/ksh DSHOME=/usr/local/Ascential/DataStage/DSEngine export DSHOME . $DSHOME/dsenv $DSHOME/bin/dsjob -run \ -mode RESET \ -warn 10000 MANC pa1 $DSHOME/bin/dsjob -run \ -param '$APT_CONFIG_FILE=/usr/local/Ascential/DataStage/Configurations/node1.apt' \ -param '$APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_N...

./rama1.sh[17]: -param: not found
./rama1.sh[21]: -param: not found

it tells me the line number param not found, but everything looks fine

in dsjob when I get error in param how do i find the bug