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

["Alexander, Steven" <Steven.Alexander@sanjoseca.gov>]

An SQR program that ends in an error will perform a rollback.  Of course, if
you've executed an explicit commit in your program, those changes will
remain in the database.  Also, if you truncate a table, that cannot be
rolled back.


-----Original Message-----
From: Moran, Patrick T. [mailto:Patrick.Moran@trincoll.edu] 
Sent: Monday, September 25, 2006 8: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