Man page or keyword search:   man All Sections 1 - General Commands 2 - System Calls 3 - Subroutines, Functions 4 - Special Files 5 - File Formats 6 - Games and Screensavers 7 - Macros and Conventions 8 - Maintenence Commands 9 - Kernel Interface New Commands Server 4.4BSD AIX Alpinelinux Archlinux Aros BSDOS BSDi Bifrost CentOS Cygwin Darwin Debian DigitalUNIX DragonFly ElementaryOS Fedora FreeBSD Gentoo GhostBSD HP-UX Haiku Hurd IRIX Inferno JazzOS Kali Knoppix LinuxMint MacOSX Mageia Mandriva Manjaro Minix MirBSD NeXTSTEP NetBSD OPENSTEP OSF1 OpenBSD OpenDarwin OpenIndiana OpenMandriva OpenServer OpenSuSE OpenVMS Oracle PC-BSD Peanut Pidora Plan9 QNX Raspbian RedHat Scientific Slackware SmartOS Solaris SuSE SunOS Syllable Tru64 UNIXv7 Ubuntu Ultrix UnixWare Xenix YellowDog aLinux   44335 pages apropos Keyword Search (all sections) Output format html ascii pdf view pdf save postscript

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 param‐
       eter 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 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)

       -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)

Vote for polarhome