Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2011

    Question Unanswered: [help]make some insert transaction can rollback??

    dear guys,

    now i have a enhancement project to improve effeciency of job schedule in as/400.

    overall, description of the job is to insert and delete a few of file/physical file.

    but in old version, that job just using common function of as/400 like WRITR, DELT, UPDAT, etc.

    in new version, i want to re-make that logic with SQL statement.

    but in the progress, i found a problem, if i use SQL statement, when the job have execute a few of insert statement, and suddenly i ended the job, the record won't rollback.

    i have been try some method, like : SET TRANSACTION, DECLARE PROCEDURE. But they don't solve my problem.

    Fyi, i am using AS/400 SMART ver 2009-04. Can you help me to solve my problem?

    thank you before
    Last edited by Bey; 09-13-11 at 22:50.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts