|BSQLODBC(FreeTDS)||FreeTDS (freetds reference manual)||BSQLODBC(FreeTDS)|
bsqlodbc — batch
SQL script processor using ODBC
bsqlodbc is a utility program distributed
bsqlodbc is a non-interactive equivalent
of the ‘
isql’ utility programs
distributed by Sybase and Microsoft. Like them,
bsqlodbc uses the command
go’ on a line by itself as a
separator between batches. The last batch need not be followed by
bsqlodbc makes use of the ODBC API
provided by FreeTDS. This API is of course also available to application
- Database server login name.
- Database server password.
- Database server to which to connect.
- Database to use.
- Name of script file, containing SQL.
- Name of output file, holding result data.
- Name of file for errors.
- Specifies the field terminator. Default is two spaces (
\t’ ), carriage return ( ‘
\r’ ), newline ( ‘
\n’ ), and backslash ( ‘
- Print column headers with the data to the same file.
- Do not print column metadata, return status, or rowcount. Overrides
- Verbose mode, for more information about the ODBC interaction. This also
reports the result set metadata, including and return code. All verbose
data are written to standard error (or
-e), so as not to interfere with the data stream.
- Specify ODBC version (2 or 3).
bsqlodbc is a filter; it reads from
standard input, writes to standard output, and writes errors to standard
-e options override these defaults.
bsqlodbc exits 0 on success, and >0 if
the server cannot process the query.
bsqlodbc first appeared in FreeTDS
bsqlodbc utility was written by
James K. Lowden
|March 25, 2015||FreeTDS 1.3.6|