Re: [sqr-users] Auto-commits

[amy.harvel@phoenix.gov]

Place a Rollback in your program before the end of the program.  If you 
are using PeopleSoft put the rollback before the reset and sttapi-term

       Rollback
       Show 'Rolling Back Database'
 do RESET
 do STDAPI-TERM
 do Get-Current-DateTime
 show $ProgName ' Completed Successfully at ' $AsOfNow ' on ' $AsOfToday

Amy M. Harvel
City Of Phoenix Information Technology Department
Programmer III
602-261-8974




"Poonam Auluck" <poonam.auluck@ams.com>
Sent by: sqr-users-admin@sqrug.org
01/06/2003 01:26 PM
Please respond to sqr-users

 
        To:     "'sqr-users@sqrug.org'" <sqr-users@sqrug.org>
        cc: 
        Subject:        [sqr-users] Auto-commits


Hi All - I was wondering if anyone came across turning the auto-commit
functionality off in SQR.  I would like to insert some rows into a table,
but I don't want to commit it.  I just want the data to be temporarily
sitting in there.

I thought there was a flag or maybe someplace that I can turn this off, 
but
I can't find it.  I thought the flag was -XC, which should suppress the
database commit when the report has finished running, only when I use this
in the command line, I get an error saying it doesn't understand it.
Should I be typing in something else along w/ '-XC'...Do I have to put
'False' in there somewhere?

Any help is appreciated!
Thanks!


_________________
Poonam Auluck
AMS, Inc.
703-227-5576


.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users