BSQLODBC(1)

📦
version 1.5.20 · 12 versions
, in arch rolling

🦋 NAME — BSQLODBC(1) 🦋

okay so bsqlodbc is the batch SQL script processor using ODBC, and this is its local manual page, bestie. 💖

✨ 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. 🫶

It's the 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. No cap. 🎀

bsqlodbc makes use of the ODBC API provided by FreeTDS. This API is of course also available to application developers. slay. ✨

🎀 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. Overrides -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. periodt. 💅

🔥 EXIT STATUS 🔥

bsqlodbc exits 0 on success, and >0 if the server cannot process the query. 🫡

🌈 HISTORY 🌈

bsqlodbc first appeared in FreeTDS 0.65. iconic. 👑

💜 AUTHORS 💜

The bsqlodbc utility was written by James K. Lowden <jklowden@freetds.org>. 🫶

this local page is from FreeTDS 1.5.20, dated March 25, 2015, and it's the BSQLODBC(FreeTDS) manual — mwah 💋

📦 where this page comes from