unixODBC

unixodbc

Runs as isql, odbcinst|macOS, Linux|www.unixodbc.org

Command form

ai-draft · 2 tasks · 8 fields

Opens isql against a DSN, or runs SQL from standard input in batch mode. The password argument is left out so it is not typed into shell history; isql prompts or reads it from the DSN.

Opens the form; the finished command lands at your prompt, unrun

Run in Otty

otty gui unixodbc

Connect with isqlExample values, fixed in this page — nothing here reaches a terminal

Basic

Data source name (DSN)*

string

User

string

Advanced

Verbose errors

-v

TasksEach one presets the form for one job

Interactive session

dsnuserverbose

Batch query to delimited text

dsnuserbatchdelimitercolumn_namesquote

ParametersOnly these flags are editable in the form

Data source name (DSN)

string · positional 0

User

string · positional 1

Batch mode (SQL from stdin)

boolean

-b

Column delimiter

string

-d

Print column names

Needs a column delimiter.
boolean

-c

HTML table output

boolean

-w

Quote character fields

boolean

-q

Verbose errors

boolean

-v

SourcesEvery flag above is checked against these

manual

isql DSN [USER [PASSWORD]] [options] -b Run 'isql' in non-interactive batch mode. In this mode, 'isql' processes -dDELIMITER Delimit columns with the specified delimiter. -w Format the result as an HTML table. -c Output the names of the columns on the first row. This option can only be used with the -d or -x options. -q Wrap the character fields in double qu…

manual2.3.14

manpages.debian.org

Before it fills your prompt, Otty checks the installed isql against its version. A form that does not match your version is not offered.