User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To activate the ISQL configuration window.

Syntax

     CONFIGURE

Usage

ISQL.

Permissions

None.

Side effects

None.

See also

• SET OPTION statement

Description

The CONFIGURE statement activates the ISQL configuration window. This window displays the current settings of all ISQL options. It does not display or allow you to modify database options or options for other software that are stored in the database. The SET OPTIONS statement (see "SET OPTION statement") allows you to set all options---ISQL, database and other options.

The Tab key can be used to change fields. If a hardware cursor appears in a field, then you are allowed to type a value for the option. If the hardware cursor does not appear, you can use the cursor up and down keys to select one of the allowed values. When you have changed the options, press enter to save the changes and exit, or escape to undo the changes and exit.

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