Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
BSQLODBC(FreeTDS)	   FreeTDS Reference Manual	     BSQLODBC(FreeTDS)

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 command
     `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.00.131		March 25, 2015		  FreeTDS dev.1.00.131

NAME | SYNOPSIS | DESCRIPTION | OPTIONS | NOTES | EXIT STATUS | HISTORY | AUTHORS

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=bsqlodbc&sektion=1&manpath=FreeBSD+12.1-RELEASE+and+Ports>

home | help