ttLockLevel
ttLockLevel
again. The initial value depends on the LockLevel
connection attribute. See LockLevel for full details of the different locking levels.
Required Privilege
This procedure requires the ADMIN
privilege.
Usage in TimesTen Scaleout and TimesTen Classic
This procedure is supported in TimesTen Classic but not supported in TimesTen Scaleout.Related Views
This procedure has no related views.
Syntax
ttLockLevel('lockLevel')
Parameters
ttLockLevel
has the parameter:
Parameter | Type | Description |
---|---|---|
|
|
Locking level for the connection. |
The value of lockLevel
may be one of two case-insensitive strings:
Row
: Locking should be set to row-level locking.
DS
: Locking should be set to database-level locking.
Result Set
ttLockLevel
returns no results.
Examples
CALL ttLockLevel ('Row');
Notes
-
This procedure does not affect the current transaction.
-
Row-level locking is required when caching tables from an Oracle database.
-
This procedure must be called from within a transaction. It has the effect of setting the locking level for subsequent transactions for the connection that invoked it. The new lock level does not affect the current transaction. It takes effect at the beginning of the next transaction.
See Also