DSXchange

The two active stage will might be combined as single operator for function. And hence the JonMon might not record the statistics. Not only for Copy and Transformer, but its for may cases. Like Modify to Modify, Peek etc., Try selecting the Force copy.

Why do you want to look at the server guide if you need PX. I am not at PX site right, but commands like dsjob, dssearch should be in Designer or developers guide. I guess dsrecord is not documented in manuals, but it is avaialble in Orchestrate manuals.

You ll need to find MAX for previous run and write it into to a file and pass it as a parameter using ExecuteCommand Activity as CommandOutput or as mentioned, use MAX(field) during extraction (if its on same database.)

Should be in your online manuals available in you Client machine.

Try without the ; at the end. Or try Call DSExecute("UV","SELECT MAX(CAST(JOBNO AS INTEGER)) FROM DS_JOBS", Output, ReturnCode)
BTW: What you get from Max of JobNo. Hope you know that it wont be equal to COUNT of Jobs available in Project.

Implicit conversion from source type "Int32" to result type "Decimal".

User Transformer or Modify stage and try using StirngToDecimal() function.

Are there any example job available in each project? Or is it refering to built in routines etc.

If you complex and large transformation, PX will help you on that part.

Since server jobs are lacking in IsValid() function. Follow Ray's approach to use Status() to check if the conversion using ICONV() is valid and assing NULL based on the result.

In addition it also depends on the number of field. Hundreds of fields in Dataset will be slower in extraction than fewer fields in sequential file. Is it a outer join? If os on which stream?

You may need to use your official company email address for login. Check if email been blocked from IBM in you email server.

Why can the job or the Jobcontrol be scheduled for every x min? So that the cron can be changed as any point of time. Or you can isolate the Sleep into seperate entity. Say in Execute command activity. Once stop signal is initiated, the flow will stop after Execute command activity finish executing....

Is it a fixed width file? That case, there is chance where the data extraction might be wrong. Merge doesn't shuffles the field values.

Was that the full fatal error message? Don't you get more info if you double click the log event?

Try 827. Have you tried passing the Header and Body file into CFF stage which has only Body metadata with a Reject option enabled?