Re: [sqr-users] Auto-commits

["Jeffrey Bedell" <Jkbedell@syr.edu>]

As the last step in your program, do a rollback.

Jeffrey K. Bedell
Senior Systems Analyst
Information Systems
Syracuse University
(315) 443-9273

>>> poonam.auluck@ams.com 01/06/03 03:26PM >>>
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