Entering content frame

Function documentation Multiple Line Mode Locate the document in its SAP Library structure

Use

This mode enables you to enter long commands on several lines. SQLCLI saves multiple line commands in an internal command buffer (Page 8).

Prerequisites

You have called the SQLCLI program in multiple line mode:

sqlcli [<options>] -m

Activities

To start a new row, choose Enter.

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

Example

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

sqlcli -d HOTELDB -u MONA,RED

Entering a multiple line SQL statement:

select
*
from
CUSTOMER

Executing the SQL statement:

\g

See also:

Editing a Multiple Line Command in an External File (Page 8)

 

Leaving content frame