User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To find the current setting of an option.

Syntax

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

Parameters

     userid:        identifier, string or host-variable

     sqlda-name:    identifier

     option-name:    identifier, string or host-variable

     host-variable:    indicator variable allowed

Usage

Embedded SQL.

Permissions

Must have DBA authority to get someone else's option settings.

Side effects

None.

See also

• SET OPTION statement

Description

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.

Example

     EXEC SQL GET OPTION 'date_format' INTO :datefmt;