debian man page for isql

Query: isql

OS: debian

Section: 1

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

isql(1) 							UnixODBC Reference							   isql(1)

NAME
isql - utility to submit SQL queries to a data source. iusql - Unicode version of isql.
SYNOPSIS
isql DSN [UID [PWD]] [options]
DESCRIPTION
isql can be used to submit SQL to a data source and to format/output results. It can be used in batch or interactive mode.
OPTIONS
DSN Name of the data source you want to connect to. UID Your login to connect the DSN. PWD Your password needed to login to the DSN. -b Batch mode. It will not do any prompting. -dx Delimit columns with x. -x0xXX Delimit columns with XX, where XX is in hex. For example -x0x09 will use a tab. -w Wrap results in an HTML table -c Print column names on first row. This options only has effect in combination with the -d option. -mn Limit column display width to n -v Verbose output. --version This prints the version.
EXAMPLES
cat My.sql | isql WebDB MyID MyPWD -w Each line in My.sql must contain exactly 1 SQL command except for the last line which must be blank.
AUTHOR
This manual page was written by Kurt Roeckx <kurt@roeckx.be> for the Debian package of unixODBC. UnixODBC Dec 2004 isql(1)
Related Man Pages
isql(1) - debian
odbcinst(1) - debian
iusql(1) - centos
iodbctest(1) - osx
iodbctestw(1) - osx
Similar Topics in the Unix Linux Community
a better way to grep until end of error message, although most seem to be 1 or 2 line
how to add ; at the end of last line
SQL for table with column (varchar2 2000) and line break in it
Format options while Redirecting output of sql to a file in shell
I want query output to send on mail using table tag and output should be in table