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


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


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.


  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


  3. Execute the SQL statement.