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.
