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


Chapter 15 Preparing the Environment, Analyzing Returned Values, and Modifying Changes : Committing and Rolling Back Persistent Table Changes

Committing and Rolling Back Persistent Table Changes
If you specify COMMIT or ROLLBACK as the parameter to the STOPTR operation, your client program can issue a COMMIT or ROLLBACK.
Notes
Within a started transaction, and before it is ended, you can COMMIT or ROLLBACK changes made by the data access statements INSERT, REPLACE, and DELETE to persistent TDS or external database tables.
Sample Calls
COBOL Call to Perform a COMMIT

 
COPY HRNHLWAC
COPY HRNHLIST
.
.
01 HRN-STOPPRARM.
05 STOPPARMLEN PIC9(4) USAGE COMP-4 VALUE 6.
05 STOPPARMDAT PICX(6) VALUE 'COMMIT'.
.
.
CALL 'HRNHLLTM' USING HRNHLLWA 'STOPTR'
HRN-NULL-LIST HRN-STOPPARM HRN-NULL-LIST HRN-NULL-LIST
HRN-RETURN-DATA HRN-RETURN-CODE.

 
Non Re-entrant Assembler Call to Perform a COMMIT

 
CALL HRNHLLTM,(HRNHLLWA,C'STOPTR',0,STOPPARM,0,0,DATA,CODE),VL
.
.
STOPPARM CD AL2(6),C'COMMIT'
DATA DS CL180 REASON CODE FROM HRNHLLTM
CODE DS F RETURN CODE FROM HRNHLLTM

 
Returned Values
 
Return Codes
STOPTR with COMMIT or ROLLBACK request failed. The first four bytes of the RETURN-DATA parameter are set to the reason code. Refer to Call Level Interface Reason Codes.

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