espquery(1)

NAME
     espquery - Database query for Embedded Support Partner

SYNOPSIS
     espquery [-th] [-u username] [-p password] [-n hostname] -s sqlstring dbname

DESCRIPTION
     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
     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
     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.