Entering content frame

Procedure documentation Executing an SQLCLI Command Locate the document in its SAP Library structure

Prerequisites

For some SQLCLI commands, you need to log on to a database instance (Page 4).

Executing an individual command in interactive mode

...

       1.      Call the SQLCLI program:

sqlcli [<options>]

You can specify call options (Page 13).

       2.      Enter the SQLCLI command (Page 5).

You can also enter SQCLI commands in multiple line mode (Page 7).

Executing several commands from a batch file

...

       1.      When you call the SQLCLI program, enter the path and name of the batch file (Page 6) from which you want to read the commands.

sqlcli [<options>] -i <file>

Example

Displaying general information about the database instance HOTELDB as user MONA with the password RED:

sqlcli -d HOTELDB -u MONA,RED \s

host          : localhost
database      : HOTELDB
xuserkey      :
user          : MONA
kernel version: KERNEL    7.5.0    BUILD 008-103-056-908
sapdbc version: libSQLDBC 7.5.0    BUILD 008-103-056-820
unicode       : NO
default code  : ASCII
sql mode      : INTERNAL
autocommit    : ON

See also:

Executing an SQL Statement (Page 9)

 

Leaving content frame