Administrative API Reference

sqleSetTypeCtx - Set Application Context Type

Sets the application context type. This API should be the first database API called inside an application.

Scope

The scope of this API is limited to the immediate process.

Authorization

None

Required Connection

None

Version

sql.h

C API Syntax

int sqleSetTypeCtx ( long lOptions);

API Parameters

lOptions

Input. Valid values are:

SQL_CTX_ORIGINAL

All threads will use the same context, and concurrent access will be blocked. This is the default if none of these APIs is called.

SQL_CTX_MULTI_MANUAL

All threads will use separate contexts, and it is up to the application to manage the context for each thread. See

• sqleBeginCtx - Create and Attach to an Application Context

• sqleAttachToCtx - Attach to Context

• sqleDetachFromCtx - Detach From Context

• sqleEndCtx - Detach and Destroy Application Context.

The following restrictions/changes apply when this option is used:

• When termination is normal, automatic COMMIT at process termination is disabled. All outstanding transactions are rolled back, and all COMMITs must be done explicitly.

• sqleintr - Interrupt interrupts all contexts. To interrupt a specific context, use sqleInterruptCtx - Interrupt Context.

Usage Notes

This API must be called before any other database call, and only the first call is effective.

[ DB2 List of Books | Search the DB2 Books ]