DragonFly On-Line Manual Pages

Search: Section:  

sqlrsh(1)                          SQL Relay                         sqlrsh(1)


NAME

       sqlrsh - interactive query tool for SQL Relay


SYNOPSIS

       sqlrsh -host host -port port -socket socket -user user -password passwd
       [-script script]
       sqlrsh [-config configfile] -id id [-script script]


DESCRIPTION

       sqlrsh is an interactive query tool similar to (though not as powerful
       as) SQL Plus, mysql, psql, isql and the like. Run it and type help; at
       the prompt for detailed usage instructions. When sqlrsh starts up, it
       reads and executes two rc files, the system rc file
       (/etc/sqlrelay/sqlrshrc on Debian) and a personal rc file .sqlrshrc in
       your home directory. These files should contain sqlrsh commands, ending
       in semicolons, seperated by carraige returns. Any commands may be used
       in the rc files, even queries.


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)

       -script script
              script (containing sqlrsh commands and queries) to run (default
              ~/.sqlrshrc)


EXAMPLES

       sqlrsh -socket /tmp/examplesocket -user fred -password secret
              Connect to the SQL Relay listener daemon running on the local
              machine, with socket /tmp/examplesocket, as user fred, with
              password secret.

       sqlrsh -host dbsvr -port 9000 -user fred -password secret
              Connect to the SQL Relay listener daemon running on the remote
              machine dbsvr, on port 9000, as user fred, with password secret.

       sqlrsh -id example
              Connect to the SQL Relay listener daemon for instance example
              (as defined in /etc/sqlrelay/sqlrelay.conf).


SEE ALSO

       fields(1), query(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).

interactive query tool            2002-06-10                         sqlrsh(1)

Search: Section: