ttOptGetFlag

This procedure returns the optimizer flag settings for the current transaction. The results are returned as a result set that can be retrieved using the ODBC SQLFetch function or the JDBC ResultSet.getXXX() 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
`flagName`	`TT_CHAR (32)`	Name of the flag whose value is to be returned. If `NULL` is passed, the values of all flags are returned.

Result Set

ttOptGetFlag returns the result set:

Column	Type	Description
`flagName`	`TT_VARCHAR (32) NOT NULL`	Name of the flag. See "ttOptSetFlag" for a description of possible flag values.
`value`	`TT_INTEGER NOT NULL`	Current flag value, either `0` or `1`.

Examples

CALL ttOptGetFlag('TmpHash');