DSXchange

Hi

i am executing one batfile if the batfile failed i need to abort my job i am able get the status of that batfile "F" or "P". i want to abort my job if it is "F"

Help me, Thanks in Advance


Vijay

Where are you running this 'bat file'? Typically, you'd just need to ensure the batch returned a zero return status when everything went well and a non-zero return status when there was a problem.

... or you could specifically check for the 'F' versus 'P' and branch a Sequence job off to a Terminator stage when it sees 'F'.

i am getting the status F or P in stage varibale this is ok.
My probelm is i want to abort the job if the status of stage varibale is F.

Vijay

we dotn have any dstransform or commands to do this from job..

Again - where exactly are you calling this batch file? And if you want to abort based on a stage variable, you can do that in another one. For example, something like this
Or something similar.

i am calling this batfile in a routine using "Call DSExecute("DOS","E:\DATAFILES\SOURCE\TBillTrxn_Batch.bat",Output,SystemReturnCode)"

This status i am taking in a stage varibale...

So, inside the job once for every record processed? Regardless...

You could 'abort the job' from inside your routine if you liked, or take the code sample I posted and run with it. In either case, abort by writing a Fatal log message.

Thank You "chulett"

Glad I could help, "vijaydev".

Let me get this right in my head. For every row processed you are:

• deriving a stage variable
  
  invoking a routine
  
  invoking a DOS shell
  
  executing a BAT file
  
  recovering its exit status
  
  making a decision about aborting based on a constraint expression [Reject]

Don't you think there might be too many layers of software here? What's the BAT file doing that couldn't be done in the stage variable expression or, perhaps, in the routine?


Doubtless you'll be back soon seeking ways to improve the performance.