SET

identifies the option and a value for it. The available options and values are listed here:

Initial setting is OFF.

If ON, a COMMIT WORK statement is automatically performed: 1) when you are using the INPUT or LOAD command and you enter the number of rows defined in the AUTOSAVE option, 2) when you enter END to terminate the INPUT command, or 3) after a module has been installed with the INSTALL command.

If OFF, rows inserted with the INPUT command are committed only when you enter COMMIT WORK. Rows inserted with the LOAD command or modules installed with the INSTALL command are committed only when you enter COMMIT WORK.

Initial setting is OFF.

If ON, ISQL automatically acquires an exclusive lock upon the table when the LOAD command is executed. Setting AUTOLOCK to ON improves performance when large data files are loaded.

The LOAD command does not automatically lock the table.

Initial setting is 5.

If AUTOCOMMIT is ON, ISQL will continue to load rows with the INPUT or LOAD command until the load buffer is full, even if the NumberOfRows specified has been exceeded. Once the load buffer is full, a check is made to see if the NumberOfRows value has been reached or exceeded. If this is the case ISQL processes a COMMIT WORK statement.

NumberOfRows can be from 0 through 2,147,483,647. When using the LOAD command for large data files, you should increase NumberOfRows above the initial setting of 5. For the INPUT command, NumberOfRows should not be greater than 300.

Initial setting is ON.

If ON, ISQL continues processing commands from a command file after encountering an error.

If OFF, ISQL terminates command file processing after encountering an error.

If ASCII, the LOAD command converts the data in an external file from IBM mainframe format to an ALLBASE/SQL data type. Character data in the external file is in ASCII format.

If EBCDIC, the LOAD command converts the data in an external file from IBM mainframe format to an ALLBASE/SQL data type. Character data in the external file is in EBCDIC format.

Initial setting is OFF. If OFF, the LOAD command will not convert the data in an external file.

If ON, commands and comments in command files are displayed as they are read from the command file.

Initial setting is OFF.

If OFF, commands and comments read from command files are not displayed.

If ON, batch user input is echoed to standard out.

Initial setting is OFF.

If OFF, batch user input is not echoed.

Initial setting is /usr/bin/vi.

The named editor is invoked when you execute the EDIT command. If you do not specify a full path name, ISQL uses the search paths defined in your .profile or .cshrc file.

Initial setting is a backslash (\)

Characters with special meaning to ISQL must be preceded by the one-byte escape character when used within an ISQL command.

If ON, ISQL terminates immediately if an SQL error is encountered.

Initial setting is OFF.

If OFF, ISQL does not immediately terminate if an SQL error is encountered.

If ON, ISQL terminates immediately if an SQL warning is encountered.

Initial setting is OFF.

If OFF, ISQL does not immediately terminate if an SQL warning is encountered.

Initial setting is blank, indicating that SQL statements are not checked for standards compliance.

ISQL displays a warning for each SQL statement that does not conform to the StandardName specified. The StandardName option is not case sensitive. To turn off the flagger, issue this command without the StandardName option. See the "Standards Flagging Support" appendix in the ALLBASE/SQL Reference Manual for more information on ALLBASE/SQL standards compliance.

Initial setting is 2.

The length determines the number of digits displayed to the right of the decimal point in the output of the SELECT statement for a column containing data of type DECIMAL, FLOAT, or REAL. Length can be from 0 through 18.

Initial setting is 16,384.

The NumberOfBytes specifies the size of the buffer ISQL uses with the LOAD and UNLOAD commands.

Initial setting is ON.

If ON, ISQL reports the number of rows processed by each BULK INSERT executed by a LOAD command or each FETCH issued by an UNLOAD command. If AUTOCOMMIT is ON, ISQL displays a message each time a COMMIT WORK is automatically performed by the LOAD command.

If OFF, ISQL displays status messages for the LOAD and UNLOAD commands only after all rows have been processed.

If AT_COMMIT, ISQL only displays status messages when a COMMIT WORK is issued by a LOAD command.

Initial setting is blank.

This one-byte character is displayed when a null value occurs in a column. The NULL character can be any one-byte character, except a semicolon or a comma. To use a single or double quotation mark or the current SET ESCAPE character, precede it with the current SET ESCAPE character.

Initial setting is isqlout.

All SELECT results go to the named file. ISQL creates the file when you execute the SELECT statement. If it already exists, it is overwritten. If the file is named isqlout, it is removed when the query result display is terminated. Each line in the output file is as wide as the PAGEWIDTH setting.

If the output file contains sensitive data, verify that the file's permissions prohibit access by unauthorized users. The permissions of the output file are affected by the user's file creation mode mask. See the umask(2) and chmod(2) man pages for more information.

Initial setting is user's DBEUserID name.

This command temporarily resets the default owner name. It does not change the ownership of existing objects in the DBEnvironment nor does it change any authorities in the DBEnvironment. The new owner name must be 20 bytes or fewer in length. Setting the owner name eliminates the need to fully qualify table and view names in SQL statements. To reset the owner name to the login name, type SET OWNER with no owner name.

Initial setting is 254.

The maximum number of bytes per row of data for SELECT output is the PageWidth value. PageWidth can be as large as 32767. Blanks pad the line to the option value.

Initial setting is isql=> .

The PromptString appears when ISQL is ready to accept a command from the terminal. The PromptString can be as long as 16 bytes. If the string contains any blanks or commas, enclose the string in single or double ASCII quotes.