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.