DSXchange

Hi,

You can also achieve this by setting the trigger in that link as --
"Executed ok" OR "Execution finished with warnings".

No, both the users are same.

I have a job which extracts data from a DB2 stage, writes in a seq. file and then transfers the data to another server using a FTP stage. This job is scheduled once everyday. Strangely, in the scheduled run, everytime the job aborts saying --> ds_seqput: error in 'write()' - Error 0 / ds_seqput: err...

[quote="ray.wurlod"]You don't need a UNIX command - the Status statement in DataStage BASIC can return the size of a file in bytes. ...[/quote]


Ray, can you please describe the way you told in a bit elaborately such that it will be easier for implementation? Thanks.

I think very simply we can call the SP after the job. Make one job with some table def. stage, pass some dummy column and the SP being called in the after sql part of it. then just link it to some dummy seq file. Now in a sequencer, link this job after the main job. I hope this can solve the purpose.

I have a job where the target sequential file in stored in a unix directory by using FTP stage. The requirement is to add a email notification whenthe size of the file exceeds a certain size, e.g. 5MB. Can anyone help me with the way of implementing this change? Instead of the size, if anyone sugges...