sqlrsh(1) SQL Relay sqlrsh(1)NAMEsqlrsh - interactive query tool for SQL Relay
SYNOPSISsqlrsh-host host -port port -socket socket -user user -password passwd
[-script script]
sqlrsh [-config configfile] -id id [-script script]
DESCRIPTIONsqlrsh 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/sqlre‐
lay/sqlrshrc on Debian) and a personal rc file .sqlrshrc in your home
directory. These files should contain sqlrsh commands, ending in semi‐
colons, 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 connec‐
tions
-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)
EXAMPLESsqlrsh-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 ALSOfields(1), query(1), sqlr-cachemanager(8), sqlr-connection(8), sqlr-
listener(8), sqlr-scaler(8), sqlr-start(8), sqlr-stop(8), and the docu‐
mentation 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)