Multiple Row Mode 

Use

This mode enables you to enter long commands for several rows. SQLCLI stores multiple row commands in an internal command buffer.

Prerequisites

You run the SQLCLI program in multiple row mode: You have the following options for activating the multiple row mode:

·        Call option: sqlcli [<options>] -m

·        SQLCLI Command: \mu ON

Activities

To start a new row in multiple row mode, choose Enter.

To execute the command, either close the last row either by entering a semicolon and choosing Enter or enter the command \g.

Example

Logging on to the database instance DEMODB as user MONA with the password RED in multiple row mode:

sqlcli -d DEMODB -u MONA,RED

Entering a multiple row SQL statement:

select
*
from
HOTEL.CUSTOMER

Executing the SQL statement:

\g

See also:

Editing Commands in an External File

Executing Commands