Re: Rollback in Interactive SQL

["Simon Coulter" <shc@xxxxxxxxxxxxxxxxx>]

Hello Oscar,

You wrote:
>I know that SQL allows to rollback an action you do in
>interactive SQL. But I don't know how this option works exactly.
>I mean, if for example, I did an UPDATE and a I want to undo the
>update, can I do that with the rollback?
>How have I got to do it?

Ensure the file is journalled:
        CRTJRNRCV
        CRTJRN
        STRJRNPF

Start ISQL
        STRSQL  COMMIT(*CHG)

        UPDATE file SET field = value WHERE other-field = other-value

        SELECT * FROM file

        (Realise you stuffed up)

        ROLLBACK

        --or--

        (Determine the update was correct)

        COMMIT

        F3 to exit and save SQL session

Regards,
Simon Coulter.

--------------------------------------------------------------------
   FlyByNight Software         AS/400 Technical Specialists
   http://www.flybynight.com.au/

   Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
   Fax:   +61 3 9419 0175   mailto: shc@flybynight.com.au   \ /
                                                             X
                 ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------