ASA SQL Reference
  SQL Statements

CONFIGURE statement [Interactive SQL]

Description 

Use this statement to open the Interactive SQL Options dialog.

Syntax 

CONFIGURE

Usage 

The CONFIGURE statement activates the Interactive SQL Options dialog. This window displays the current settings of all Interactive SQL options. It does not display or allow you to modify database options.

You can configure Interactive SQL settings in this dialog. If you select Make Permanent, the options are written to the SYSOPTION table in the database and the database server performs an automatic COMMIT. If you do not choose Make Permanent, and instead click OK, the options are set temporarily and remain in effect for the current database connection only.

Permissions 

None.

Side effects 

None.

See also 

SET OPTION statement

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise.