[unixODBC-support] Cannot run SQL using isql utility on AIX/DB2

Nick Gorham nick at easysoft.com
Tue Sep 21 12:30:28 BST 2004


Lee Purchase wrote:
> Hi,
> 
> 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:
> 
> 
> *[58004][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?

I don't know, I would ask IBM, I found this reference.

http://www.pdc.kth.se/doc/SP/manuals/db2-5.0/html/db2m0/sql0900.htm

-- 
Nick Gorham
Easysoft Limited



More information about the unixODBC-support mailing list