Linux Commands Examples

A great documentation place for Linux commands

iusql

Unicode version of isql.

Synopsis

isql DSN [UID [PWD]] [options]


add an example, a script, a trick and tips

: email address (won't be displayed)
: name

Step 2

Thanks for this example ! - It will be moderated and published shortly.

Feel free to post other examples
Oops ! There is a tiny cockup. A damn 404 cockup. Please contact the loosy team who maintains and develops this wonderful site by clicking in the mighty feedback button on the side of the page. Say what happened. Thanks!

examples

0

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.


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.


author

This manual page was written by Kurt Roeckx <kurt[:at:]roeckx[:dot:]be> for the Debian package of unixODBC.

How can this site be more helpful to YOU ?


give  feedback