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.
Log on to the DEMODB database in multiple line mode as user MONA with the password RED:
sqlcli -d DEMODB -u MONA,RED
Enter a multiple line SQL statement:
select * from
HOTEL.CUSTOMER
Execute the SQL statement.
\g