unixODBC - isql

Card Puncher Data Processing


An unixODBC client


isql DSN [UID [PWD]] [options]

where Options:

  • -b: batch.(no prompting etc)
  • -dx: delimit columns with x
  • -x0xXX delimit columns with XX, where:
    • x is in hex,
    • ie 0x09 is tab
  • -w: wrap results in an HTML table
  • -c: column names on first row (only used when -d)
  • -mn: limit column display width to n
  • -v: verbose
  • -lx: set locale to x
  • -q: wrap char fields in dquotes
  • -3: Use ODBC 3 calls
  • -n: Use new line processing
  • -e: Use SQLExecDirect not Prepare
  • -k: Use SQLDriverConnect. Treat the DSN as a connection string and use SQLDriverConnect isql -k “DSN=server;UID=test;PWD=test”
  • –version version


  • help - list tables
  • help table - list columns in table
  • help help - list all help options



isql -v WebDB MyID MyPWD
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |

Execute a query

With an extern file

isql WebDB MyID MyPWD -w < My.sql

Each line in My.sql must contain exactly 1 SQL command except for the last line which must be blank (unless -n option specified).

With a sql

Type the SQL in one line and after that the go statement.

select 1 from dummy
| 1          |
| 1          |
SQLRowCount returns 1
1 rows fetched



isql -v WebDB MyID MyPWD
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect


$ echo $ODBCINI

Discover More
Card Puncher Data Processing
ODBC - Client

from nqcmd See mkleehammer/pyodbc/wiki Python Script
Card Puncher Data Processing
Oracle Database - ODBC Driver Insallation on Linux

where is the data manager home () and ~/.odbc.ini === Drivers === Example odbcinst.ini === DSN === odbc.ini Minimal parameters Complete: ==== Test it ==== with ===== Support...
Card Puncher Data Processing
UnixODBC - Installation

How to install UnixODBC Installation Verification With rpm With yum: The install uses the standard GNU autoconf process Installation: as root: Verification odbc manager ...
Card Puncher Data Processing
unixODBC - Diagnostic Tracing

To trace your application behavior, first add the following line to the odbcinst.ini file: The general form is: Then you start the trace with strace. For example: Example with isql Output: ENOENT:...

Share this page:
Follow us:
Task Runner