Reference Manual
   CHAPTER 9. SQL Statements     

CONFIGURE statement [ISQL]

Function 

To activate the Interactive SQL configuration window.

Syntax 

CONFIGURE

Permissions 

None.

Side effects 

None.

See also 

SET OPTION statement

Description 

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

If you press enter and you have selected Save Options to Database the options will be written to the SYSOPTION table in the database and the database server will perform an automatic COMMIT. If you do not select Save Options to Database, the options are set temporarily and remain in effect for the current database connection only.

Standards and compatibility 

• SQL/92     Vendor extension.

• Sybase     Not supported by Adaptive Server Enterprise.