ttOptGetFlag

Description

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.

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, then 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');