GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  SQLR-QUERY (1)

NAME

sqlr-query - execute a query

CONTENTS

Synopsis
Description
Options
Examples
See Also
Authors

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), #sqlr-query(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).
Search for    or go to Top of page |  Section 1 |  Main Index


execute a query SQLR-QUERY (1) 2002-06-10

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.