RE: [sqr-users] SQR Automatic Commit or Rollback

["Bob Stone" <bstone@fastenal.com>]

yes.  If it finishes successfully it commits.  

If you have a BEGIN-SQL paragraph that returns an error from the DB and
you aren't handling that error in an ON-ERROR procedure, then the SQR
will stop in ERROR status and rollback everything up to the previous
explicit commit (and it sounds like you don't have any of those).  

This would mean everything is rolled back if there are no COMMIT
statements in the SQR.

-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org] On Behalf Of
Moran, Patrick T.
Sent: Monday, September 25, 2006 10:56 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] SQR Automatic Commit or Rollback

I'm trying to verify the cause of data errors that seem to be occurring
from running an SQR program that experiences errors at runtime.

 

The Landres SQR book states on p.99 that "When your program finishes
without errors, Commit is performed by SQR automatically."  I can't seem
to find it written anywhere, but can I assume that a rollback is
automatically performed by SQR if an error occurs in your program that
performs table changes in Begin-SQL paragraphs?  If that is indeed the
case, it would explain what I am seeing in our data after the errors
occurring during the run of a particular SQR program.

 

Thanks in advance for any insight you may give.

 

Pat

 

Patrick T. Moran 
Applications Specialist, Administrative Systems  LITC-B33 

Trinity College 300 Summit Street Hartford, CT 06106 

Voice: 860.297.2223   Fax: 860.297.2569 
Email: patrick.moran@trincoll.edu

 

_______________________________________________
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