This directive provides OpenESQL with specifications for managing run-time transactions and, in some cases, enabling compile-time
                  checking. 
                  	  
               
            
 
            	 
            
               Syntax:
 
               		 
               		TRANSACTION={GLOBAL | LOCAL | MIXED} 
               	   
            	 
            
               Parameters:
 
               		 
               		
               
                   
                     			 
                      
                        				
                         
                           				  
                           | GLOBAL | Manages transactions using a distributed transaction manager such as CICS, Tuxedo, or COM+. | 
 
                        				
                         
                           				  
                           | LOCAL | Manages transactions using the data source (default). | 
 
                        				
                         
                           				  
                           | MIXED | Manages transactions using a distributed transaction manager, but does not perform compile-time checking. Use this option
                              when you need to mix GLOBAL and LOCAL transaction behavior with different data sources. | 
 
                        			 
                      
                     		  
                  
                 
               	 
              
            	 
            
               Scope:
 
               		 
               		
               
                   
                     			  
                     			  
                     			 
                      
                        				
                         
                           				  
                           | Used at compile time: | Yes | 
 
                        				
                         
                           				  
                           | Behavior at run time: | N/A | 
 
                        			 
                      
                     		  
                  
                 
               		
               See 
                  		  Scope - OpenESQL SQL Compiler Directive Options for more information.