ttOptGetFlag
SQLFetch
function or the JDBC ResultSet.get
XXX
()
method, just like the result of a SQL SELECT
statement. Applications can request the value of a specific optimizer flag by passing the flag name to ttOptGetFlag
. Alternatively, applications can request the values of all the optimizer flags by passing NULL
. The optimizer flags and their meanings are described under the ttOptSetFlag
built-in procedure.
Required Privilege
This procedure requires no privilege.
Usage in TimesTen Scaleout and TimesTen Classic
This procedure is supported in TimesTen Classic.
TimesTen Scaleout applications can call this built-in procedure.
In TimesTen Scaleout, this procedure runs locally on the element from which it is called.
Related Views
This procedure has no related views.
Syntax
ttOptGetFlag('flagName')
Parameters
ttOptGetFlag
has the parameter:
Parameter | Type | Description |
---|---|---|
|
|
Name of the flag whose value is to be returned. If |
Result Set
ttOptGetFlag
returns the result set:
Column | Type | Description |
---|---|---|
|
|
Name of the flag. See "ttOptSetFlag" for a description of possible flag values. |
|
|
Current flag value, either |
Examples
CALL ttOptGetFlag('TmpHash');
See Also