DSXchange

Is this the exact message from the DataStage Log File that you've shared :?: Just curious as I've always had DataStage returning the data record on unique constraint violation errors in the log file :) In addition to this, what is the unique constraint (being violated) definition on the database obj...

What is your actual requirement and why would the sql file not work for you

Just curious as there may be a better way based on your requirement

Try this:
[code]
Call DSExecute("UNIX", $ORALE_HOME/../sqlplus/$COMMAND , Result, ReturnCode)
[/code]

Not sure if I understand this correctly :? , you would like to submit a batch script on some remote WIN server (SERVER 2) through the DataStage Engine, again on a WIN box, which is on a different machine (SERVER 1) :?: Does the ssh2 command successfully initiate this batch script on SERVER 2 when su...

Hi All, I got my hands on a new machine with XP on it :) , installed DS 7.1 client and connected to a remote UNIX DS server 8) . The issue is, I am unable to view the conditional triggers which have been established in between the different job activities in the sequences. :roll: :arrow: Any inputs ...

Hi guyz, I encountered a strange issue with a Sequence. The sequence was supposed to trigger a job and then based on the success/failure of the job, a second job activity was to be triggerred. The strange part was that the first job never got triggerred but its status was reflected as finished OK in...