DragonFly On-Line Manual Pages

Search: Section:  

sqlr-query(1)                      SQL Relay                     sqlr-query(1)


NAME

       sqlr-query - execute a query


SYNOPSIS

       sqlr-query -host host -port port -socket socket -user user -password
       passwd -query query [-debug]
       sqlr-query [-config configfile] -id id -query query [-debug]


DESCRIPTION

       The sqlr-query command executes the query specified in the query
       parameter and returns the result set as a quote/comma/return seperated
       value list to standard output.


OPTIONS

       -host host
              hostname of the machine running the listener daemon

       -port port
              port number the listener daemon is listening on, for local or
              remote connections

       -socket socket
              socket the listener daemon is listening on, for local
              connections

       -user user
              SQL Relay user name (as per config file)

       -password passwd
              SQL Relay password (as per config file)

       -config configfile
              config file to use (default /etc/sqlrelay/sqlrelay.conf)

       -id id instance to use (as per config file)

       -query query
              query to be executed

       -debug produce debugging output


EXAMPLES

       sqlr-query -socket /tmp/examplesocket -user fred -password secret
       -query "select * from tbl"
              Connect to the SQL Relay listener daemon running on the local
              machine, with socket /tmp/examplesocket, as user fred, with
              password secret, and run a query.

       sqlr-query -host dbsvr -port 9000 -user fred -password secret -query
       "select * from tbl" -debug
              Connect to the SQL Relay listener daemon running on the remote
              machine dbsvr, on port 9000, as user fred, with password secret,
              and run a query, producing extra debugging output.

       sqlr-query -id example -query "select * from tbl"
              Connect to the SQL Relay listener daemon for instance example
              (as defined in /etc/sqlrelay/sqlrelay.conf), and run a query.


SEE ALSO

       sqlr-fields(1), sqlrsh(1), sqlr-cachemanager(8), sqlr-connection(8),
       sqlr-listener(8), sqlr-scaler(8), sqlr-start(8), sqlr-stop(8), and the
       documentation in /usr/share/doc/sqlrelay.


AUTHORS

       This manual page was written by Andreas Tille <tille@debian.org> and
       Florian M. Weps <fweps@pop.agri.ch>, for the Debian GNU/Linux system
       (but may be used by others).

execute a query                   2002-06-10                     sqlr-query(1)

Search: Section: