If THREAD is set to ISOLATE, all connections, cursors and so on are local to the thread that creates them. This is required for multi-threaded application server environments such as IIS/ISAPI. With THREAD=SHARE, 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. With THREAD=ISOLATE, each thread gets its own connection.
Syntax:
THREAD={SHARE | ISOLATE}
Scope:
Used at compile time:
|
No
|
Behavior at run time:
|
Process
|
See
Scope - OpenESQL SQL Compiler Directive Options for more information.