COMMIT
  
  SQL - Language Statements
 
 
  
   COMMIT
  
  
   Commits the current transaction
  
   
  
 
  
   1998-09-08
  
  
COMMIT [ WORK | TRANSACTION ]
  
  
  
   
    1998-09-08
   
   
    Inputs
   
   
    None
   
  
   
  
   
    1998-09-08
   
   
    Outputs
   
   
       
	
	 
	  END
	 
	 
	  
Message returned if the transaction is successfully committed.
	  
	 
	
	
	 
	  NOTICE EndTransactionBlock and not inprogress/abort state
      
      
       
	If there is no transaction in progress.
       
      
     
    
   
  
 
  
 
  
   1998-09-08
  
  
   Description
  
  
   COMMIT commits the current transaction. All
   changes made by the transaction become visible to others
   and are guaranteed to be durable if a crash occurs.
  
  
  
   
    1998-09-08
   
   
    Notes
   
   
    The keywords WORK and TRANSACTION are noise and can be omitted.
   
   
    Use the ROLLBACK statement to abort a transaction.
   
  
 
 
  
   Usage
  
  
To make all changes permanent:
  
  
COMMIT WORK;
  
 
 
 
  
   Compatibility
  
  
  
  
   
    1998-09-08
   
   
    SQL92
   
   
    Full compatibility.