FreeBSD Manual Pages
UNTITLED() LOCAL UNTITLED() NAME bsqlodbc -- batch SQL script processor using ODBC SYNOPSIS bsqlodbc [-hqv] [-U username] [-P password] [-S server] [-D database] [-i input_file] [-o output_file] [-e error_file] [-t field_term] [-V odbc_version] DESCRIPTION bsqlodbc is a utility program distributed with FreeTDS. bsqlodbc is a non-interactive equivalent of the `isql' utility programs distributed by Sybase and Microsoft. Like them, bsqlodbc uses the com- mand `go' on a line by itself as a separator between batches. The last batch need not be followed by `go'. bsqlodbc makes use of the ODBC API provided by FreeTDS. This API is of course also available to application developers. OPTIONS -U username Database server login name. -P password Database server password. -S server Database server to which to connect. -D database Database to use. -i input_file Name of script file, containing SQL. -o output_file Name of output file, holding result data. -e error_file Name of file for errors. -t field_term Specifies the field terminator. Default is two spaces ( ` ' ). Recognized escape sequences are tab ( `\t' ), carriage return ( `\r' ), newline ( `\n' ), and backslash ( `\\' ). -h Print column headers with the data to the same file. -q Do not print column metadata, return status, or rowcount. Over- rides -h. -v 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. -V odbc_version Specify ODBC version (2 or 3). NOTES bsqlodbc is a filter; it reads from standard input, writes to standard output, and writes errors to standard error. The -i, -o, and -e options override these defaults. EXIT STATUS bsqlodbc exits 0 on success, and >0 if the server cannot process the query. HISTORY bsqlodbc first appeared in FreeTDS 0.65. AUTHORS The bsqlodbc utility was written by James K. Lowden <jklowden@freetds.org>. FreeTDS dev.1.4.434 March 25, 2015 BSQLODBC(FreeTDS)
NAME | SYNOPSIS | DESCRIPTION | OPTIONS | NOTES | EXIT STATUS | HISTORY | AUTHORS
Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=bsqlodbc&sektion=1&manpath=FreeBSD+Ports+14.3.quarterly>