Specifies the handling of threads with regard to connections. 
                  	  
               
            
 
            	 
            
               Syntax:
 
               		 
               		THREAD={SHARE | ISOLATE} 
               	   
            	 
            
               Parameters:
 
               		 
               		
                
                  		   
                  			 
                  - SHARE 
                     			 
                  
-  All SQL connections, cursors, etc. in an application are shared by all threads. For example, if you have a hard-coded CONNECT
                     statement and thread 1 executes it and then thread 2 executes it, thread 2 gets an error because the connection is already
                     open. 
                     			 
                  
- ISOLATE 
                     			 
                  
- ODBC only. All connections, cursors, etc. are local to the thread that creates them. This is required for multi-threaded application
                     server environments such as IIS/ISAPI. .NET applications should use COBOL run units to isolate processing of service requests.
                     			 
                  
  
            	 
             
            	 
            
               Scope:
 
               		 
               		
               
                   
                     			  
                     			  
                     			 
                      
                        				
                         
                           				  
                           | Used at compile time: | No | 
 
                        				
                         
                           				  
                           | Behavior at run time: | Process | 
 
                        			 
                      
                     		  
                  
                 
               		
               See 
                  		  Scope - OpenESQL SQL Compiler Directive Options for more information.