Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 5 The Action Statements : ROLLBACK Statement

ROLLBACK Statement
The ROLLBACK statement discards all changes made to TDS and external data since the last synchronization point. Locks are not released on the affected tables until the transaction ends.
Exceptions
None
Example
FORALL HIREDATE:
GET EMPLOYEES('MIDWEST') WHERE EMPNO=HIREDATE.EMPNO;
   EMPLOYEES.HIREDATE = HIREDATE.DATE;
   REPLACE EMPLOYEES('MIDWEST');
   END;
---------------------------------------------------------
ON GETFAIL:
   ROLLBACK;
About the Example
In this example, a ROLLBACK statement is issued so that none of the changes made to the database since the last synchronization point are applied.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved