ROLLBACK in CL program

10 pts.
Tags:
CL Program
How to use ROLLBACK command in CL program?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

According to IBM.

The Rollback (ROLLBACK) command is used to restart the current      
transaction and reestablish the last commitment boundary as the     
current commitment boundary for the commitment definition associated
with the program issuing the command.                               
                                                                    
When the ROLLBACK command is issued:                                
                                                                    
 o  Changes made to database files and other commitment resources   
    under commitment control for the commitment definition since the
    last commitment boundary was established are rolled back.       
    Updates, additions, or deletions made to the database file's    
    data since that commitment boundary are rolled back or removed, 
    and the original entries are put back in the files.  Records    
    that were added to the files remain as deleted records.  The    
    files are repositioned to the last commitment boundary.  Changes
    made to other commitment resources are rolled back as well.    
                                                                     
 o  All record locks held for files opened under commitment control
    for the commitment definition are released.                    
                                                                     
 o  Locks on object level commitment control resources, acquired   
    when the resources were created or changed during the          
    transaction, are released.                                     
                                                                     
  More information on the ROLLBACK command is in the Commitment      
  control topic collection in the IBM i Information Center at        
  http://www.ibm.com/systems/i/infocenter/.                          
                                                                     
  There are no parameters for this command.    

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: