Function documentationMultiple Line Mode Locate this document in the navigation structure

 

This mode enables you to enter long commands on several lines. SQLCLI stores multiple line commands in an internal command buffer.

More information: Command Buffer

Prerequisites

You run SQLCLI in multiple line mode. You have the following options for activating multiple line mode:

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

  • SQLCLI command: \mu ON

Activities

To start a new line in multiple line mode, press Enter.

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

Example

  1. Log on to the DEMODB database in multiple line mode as user MONA with the password RED:

    sqlcli -d DEMODB -u MONA,RED

  2. Enter a multiple line SQL statement:

    select * from

    HOTEL.CUSTOMER

  3. Execute the SQL statement.

    \g