Implicit database commit

Former Member — Tue, 26 Sep 2006 06:05:09 GMT

Hi,

I am using JOB_OPEN, JOB_SUBMIT, JOB_CLOSE FM(s) to schedule a background job. Requirement is to rollback the work (updates on database done before job submission) based on status of background job(rollback when job cancelled). But each of above 3 FM(s) process with COMMIT WORK, hence rolling back won't do good after job submission. Statment SUBMIT ~ AND RETURN can not be used as job logs are required for reference.

Is there any way to achieve the requirement or defer a implicit database commit ?

Message was edited by: Umesh Kushwah

Re: Implicit database commit

Former Member — Tue, 26 Sep 2006 06:07:28 GMT

Hi umesh,

1. each of above 3 FM(s) process with COMMIT WORK,

I don't commit work

is required for any of the above

FMs.

2. We simply have to use these 3 FMs,

and the job will get scheduled for background.

regards,

amit m.

topic Re: Implicit database commit in Application Development and Automation Discussions

Implicit database commit

Re: Implicit database commit