You execute an SQL statement, database procedure or special SQLCLI command in the SQLCLI (see Overview of the SQLCLI Commands).
Some commands require you to be logged on to the database instance.
1. Start the SQLCLI program. To do so, you can use the Call Options.
2. Enter the command.
Start the SQLCLI program and log on to the database instance DEMODB as user MONA with the password RED:
sqlcli -d DEMODB -u MONA,RED
Display general information about the database instance:
host : localhost
database : demodb
user : MONA
kernel version: KERNEL 7.6.00 BUILD 009-103-092-269
sapdbc version: libSQLDBC 7.6.0 BUILD 009-103-092-248
unicode : NO
default code : ASCII
sql mode : INTERNAL
autocommit : ON
You can find further information in the following sections:
1. Call the SQLCLI and enter the command directly.
sqlcli [<options>] <command>
sqlcli -d DEMODB -u MONA,RED \s
If you want to enter an SQL statement or a database procedure as a command, put the SQL statement/database procedure in quotation marks.
sqlcli –d DEMODB –u MONA,RED ?select CNO,TITLE,FIRSTNAME,NAME,ZIP from HOTEL.CUSTOMER?
The SQLCLI executes the command and then ends itself.
If you are in interactive mode, enter the path and name of the batch file<file> from which the SQLCLI is to export the command as follows:
? If you are working in command mode, enter the path and name of the batch file <file> as follows when you log on to the database instance:
sqlcli [<options>] -i <file>