isql DSN [UID [PWD]] [options]
where Options:
isql -v WebDB MyID MyPWD
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
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).
Type the SQL in one line and after that the go statement.
select 1 from dummy
go
+------------+
| 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
/u01/app/oracle/product/fmw/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/odbc.ini