man isql (Commandes) - utility to submit SQL queries to a data source. iusql - Unicode version of isql.

NAME

isql - utility to submit SQL queries to a data source.

iusql - Unicode version of isql.

isql DSN [UID [PWD]] [options]

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.

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.

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.

This manual page was written by Kurt Roeckx <kurt@roeckx.be> for the Debian package of unixODBC.