Command

Description

\! <shell_command>

Executes a shell command

\?

\h[elp]

Displays all SQLCLI commands

\a[utocommit] [ON|OFF]

Switches AUTOCOMMIT mode on or off

\al[ign] [ON|OFF]

Switches formatted output of the results of SQL statements on or off

\c[onnect]

Log on to the database instance

\dc [PATTERN]

Lists all table columns that correspond to the PATTERN

SQLCLI lists only those tables to which the current user has access.

See Requesting Information About Database Objects

\de [PATTERN]

Lists all the indexes of database objects that correspond to the PATTERN

\di[sconnect]

Logs the user off the database instance

\dp [PATTERN]

Lists all database procedures that correspond to the PATTERN

\ds [NAME]

Lists all schemas that correspond to the NAME pattern

\dt [PATTERN]

Lists all tables that correspond to the PATTERN

\du [NAME]

Lists all database users that correspond to the NAME pattern

\dv [PATTERN]

Lists all views that correspond to the PATTERN

\e[dit] [<file>]

Writes the command buffer to the file <file>, where you can edit it with an editor

\f[ieldsep] <separator>

Uses the <separator> character to separate the individual fields of the result

\g

Executes the commands in the command buffer and returns the results

\i[nput] <file>

Imports commands from the batch file <file>

\m[ode] <INTERNAL|ORACLE|ANSI|DB2>

Changes the SQL mode

\mu[ltiline] ON | OFF

Activates / deactivates multiple row mode

\o[utput] <file>

Redirects the result to a file

\pa[ger]

Results are displayed successively (not page by page)

\p[rint]

Displays the current command buffer

\q[uit]

Ends SQLCLI

\r[eset]

Deletes the current command buffer

\ro[wsep] <separator>

Uses the <separator> character to separate the individual rows of the result

\s[tatus]

Displays general information about the database instance