[unixODBC-support] Cannot run SQL using isql utility on AIX/DB2
Lee.Purchase at exel.co.uk
Tue Sep 21 11:28:17 BST 2004
I've installed unixODBC-2.2.9 on a machine running AIX 5.2 and DB2 8.1.6. I'm using the isql utility provided with unixODBC to connect to a DB2 database on the same machine. I have set up a DSN in the odbc.ini file and I use the following command to connect:
isql -v e8aixdev efacs efacs
This part seems to work because I get the "Connected!" message appearing. However, if I then attempt to run any SQL (such as "select * from areacode") I get the following error:
[unixODBC][IBM][CLI Driver] SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "Unsupported function for SPMDB connect".) SQLSTATE=58004
This happens no matter what command I type (even "help"). The only command that works is "quit"!
Does anyone have any ideas what I might have done wrong?
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the unixODBC-support