Please enable JavaScript to view this site.

ESL Documentation

Configuration commands allow you to customize the behavior of, or output from, subsequent commands to this program. They are local to the application.

Command

Description

autocommit

Switches commit mode between auto (on) and manual (off).

bindfile

(DB/2 Only.) Sets the location of the bind file.

break

(SQL Server Only.) Sets the break string that is to be pre-pended to a compute row.

error

Sets the error string.

exit

Terminates the program.

fs

Sets the field separator for subsequent queries.

info

Sets the information string.

maxwidth

Sets a maximum width that will be returned by subsequent widths commands.

message

(SQL Server Only.) Sets the message output string.

null

Sets the null indicator string.

prompt

Sets the prompt string.

rs

Sets the record separator for subsequent queries.

set

Sets the display width for the specified column of a subsequent select statement.

startq

Clears all existing column formats (widths), and resets them to their default widths.

terminator

SQL Server and ORACLE Only. Sets the input statement terminator to the specified character.

verbose

Turns the verbose error reporting on or off.