Compare old row value in Data Directive FOREACH

[klincecum (Kevin Lincecum)]

Data Directive

Roberto - Standard Data Directives run as the very last event before the AppServer completes and it runs once regardless of how many records were updated. With the way your code is written, it appears to me that you will be working with the First record updated but the BPMData value will be for the Last record updated. As noted - BPMData is valid for the complete execution chain on the AppServer but it is a single record so you cannot use it in the way you are attempting.

Data Directive

Roberto - In-Transaction directives will fire for every record updated - if you update 1 record 5 different times or 5 different records one time each, the In-Tran directive will fire a total of 5 times. The Standard directive will fire only once regardless of how many records in that table were updated. For the Standard directive, the Temp Table (ttJobMtl in this case based on your example) will contain a number of records based on the update processing that occurred on that table during the …