Re: Rollback Delete Query in STRSQL ?

Dear Elvis,

Thanks v.much, its really beneficial.

Best Regards,

Luqman

"Elvis Budimlic" 
<ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> 
wrote in message news:008c01c5ba64$2a239c80$6e01a8c0@xxxxxxxx
> Probably the easiest thing to do for interactive SQL is:
>
> 1) start journaling all the files you care about, i.e.
>    STRJRNPF FILE(myLib/myFile) JRN(myLib/myJournal) IMAGES(*BOTH)
> 2) change your interactive session attributes to always run under 
> commitment
> control
>    STRSQL
>    F13
>    1
>    change Commitment Control to *ALL
>
>>From this point on, you'll always be able to simply type ROLLBACK on your
> interactive session to rollback all the changes you've made in that 
> session.
> Or if you want to keep changes without rolling them back (i.e. they're
> 'good' changes), you can and should type COMMIT instead.  Note that you
> can't rollback commited changes.
> If you use neither COMMIT or ROLLBACK and end your job, rollback will take
> place implicitly.  So make sure you use COMMIT if you want to keep any
> updates, inserts or deletes!
>
> You can start commitment control in other ways.  There is a CL command,
> i.e.:
>  STRCMTCTL LCKLVL(*ALL) CMTSCOPE(*JOB)
>
> And you could use SQL command in the interactive session itself, i.e.:
>  SET TRANSACTION ISOLATION LEVEL ALL
>
> Key is that you're already journaling before and after images, so 
> commitment
> control is able to function properly.
>
> Elvis
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On 
> Behalf Of Luqman
> Sent: Thursday, September 15, 2005 5:00 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Re: Rollback Delete Query in STRSQL ?
>
> As far as I know, I can create the journal of the table, but how can I 
> start
>
> the committment control and use transaction isolation level in STRSQL ?
> As I have never used such options on AS/400 before ?
>
>
> Best Regards,
>
> Luqman
>
>
> "Elvis Budimlic"
> <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>
> wrote in message news:031801c5b935$edd63190$6e01a8c0@xxxxxxxx
>> Yes, if you're journaling the file, have started the commitment control
>> and
>> are using transaction isolation level other than *NONE in STRSQL.
>>
>> -----Original Message-----
>> Subject: Rollback Delete Query in STRSQL ?
>>
>> Is it possible to rollback a delete or update query in STRSQL of AS/400 ?
>>
>> Best Regards,
>>
>> Luqman
>>
>>
>> -- 
>> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
>> list
>> To post a message email:
>> MIDRANGE-L@xxxxxxxxxxxx
>> To subscribe, unsubscribe, or change list options,
>> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
>> or email: MIDRANGE-L-request@xxxxxxxxxxxx
>> Before posting, please take a moment to review the archives
>> at http://archive.midrange.com/midrange-l.
>>
>>
>
>
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> To post a message email: 
> MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
>
>
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
> list
> To post a message email: 
> MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>