Re: Rollback in Interactive SQL

["Andrew Lutz" <alutz@xxxxxxxxxxxx>]

IF, if you are using commitment control and the file is journaled.

First is your file journaled?

Second check your commitment control level in ISQL (F13 then option 1).

If you are using something other than *NONE for commitment control type ROLLBACK



>>> barberao@yahoo.es 04/04/02 09:29AM >>>
Hello,

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?

TYA,

Oscar Barberá


_______________________________________________________________
Do You Yahoo!?
Yahoo! Messenger
Comunicación instantánea gratis con tu gente.
http://messenger.yahoo.es
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.