CONFIGURE Statement [Interactive SQL]

Activates the Interactive SQL (dbisql) configuration window.

Syntax

CONFIGURE

Usage

The dbisql configuration window displays the current settings of all dbisql options. It does not display or let you modify database options.

If you select 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 Permanent, and instead click OK, options are set temporarily and remain in effect for the current database connection only.

Standards

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

  • Sybase—Not supported by Adaptive Server Enterprise.

Permissions

None

Related reference
SET OPTION Statement