CONFIGURE Statement [Interactive SQL]

Activates the Interactive SQL (dbisql) configuration window.

Quick Links:

Go to Usage

Go to Standards

Go to Permissions

Syntax

CONFIGURE

Usage

(back to top)

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

(back to top)

  • SQL—Vendor extension to ISO/ANSI SQL grammar.
  • SAP Sybase Database product—Not supported by SAP Adaptive Server® Enterprise.

Permissions

(back to top)

None

Related reference
SET OPTION Statement