Reference Manual
   CHAPTER 9. SQL Statements     

GET OPTION statement [ESQL]

Function 

To find the current setting of an option. This statement is deprecated in favor of system functions.

Syntax 

GET OPTION [ userid.]option-name
... | INTO host-variable
| USING DESCRIPTOR sqlda-name

Parameters 

userid: identifier, string, or host-variable

option-name: identifier, string, or host-variable

host-variable: indicator variable allowed

sqlda-name: identifier

Permissions 

None required.

Side effects 

None.

See also 

SET OPTION statement

System and catalog stored procedures

Description 

The GET OPTION statement is provided for compatibility with older versions of the software. The recommended way to get the values of options is to use the connection_property system function.

The GET OPTION statement gets the option setting of the option option-name for the user userid or for the connected user if userid is not specified. This will be either the user's personal setting or the PUBLIC setting if there is no setting for the connected user. If the option specified is a database option and the user has a temporary setting for that option, then the temporary setting is retrieved.

If option-name does not exist, GET OPTION returns the warning SQLE_NOTFOUND.

Standards and compatibility 

• SQL/92     Vendor extension.

• Sybase     Not supported by Adaptive Server Enterprise.

Example 

• The following statement illustrates use of GET OPTION.

  EXEC SQL GET OPTION 'date_format' INTO :datefmt;