espquery(1) espquery(1)
espquery - Database query for Embedded Support Partner
espquery [-th] [-u username] [-p password] [-n hostname] -s sqlstring dbname
espquery is a command that is designed to perform limited set of
operations on the database in the Embedded Support Partner The command is
provided mostly for use by tools that are script in nature, yet need an
interface to the SSDB. The tools would have to have intimate knowledge of
the schema in the SSDB and the rights to access the database. The
operations on the on the SSDB are limited to:
SELECT [Toc] [Back]
DESCRIBE
SHOW
The dbname is a mandatory argument and must be at the end after the
option list.
The espquery command has the following options:
-t Option to disable the printing of headers. With this option,
data is displayed without any header information.
-h Help command. This option will print out the usage for the
command.
-u username The username for accessing the data in the SSDB. The SSDB
will have set users that have privileges to access the data.
This option is mandatory.
-p password The password for the account to access data in the SSDB.
-n hostname Option to connect to a different host that is running the
SSDB. By default the hostname is set to localhost. This
option is mandatory.
-s sqlstring The SQL query that is to be performed on the database. The
sqlstring must be enclosed in double quotes ("").
espquery -u sss -p sss -s "select * from event" ssdatabase
The above command connects to the database called ssdatabase on the local
system using the account sss password sss. A select of all records from
the table called event is performed.
EXAMPLE 2
espquery -n neetu.csd.sgi.com -u sss -p sss -s "select * from event"
ssdatabase
Page 1
espquery(1) espquery(1)
The above connects to the database called ssdatabase on the host called
neetu.csd.sgi.com using the account sss password sss. A select of all
records from the table called event is performed.
PPPPaaaaggggeeee 2222 [ Back ]
|
