Overview of the SQLCLI Commands

 Overview of the SQLCLI Commands

The following table shows all the SQLCLI commands that you can enter in interactive operation.

Instead of an SQLCLI command, you can also enter an SQL statement or a database procedure. For an introduction to the SQL statements available, see the SQL Tutorial. For a detailed overview of the syntax and semantics of SQL statements, see the SQL Reference Manual.

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