I'm using the perl DBD-ODBC module with Ke Jin's Unix iODBC, connecting
to Informix IDS 7.30 on HP-UX 10.20 using OpenLink's driver . All is
working well, but I would like to see the Informix error codes, and can't
figure out how to do it
As a example, if I prepare a simple select statement and misspell
the table name, I would like to see the Informix error -206, so I
could look up the error and figure out what's wrong. Instead, all I
know is that the SQLPrepare failed and return -1.
Is there a way to get the underlying database error code? Does anyone
know?
Sorry if this is an FAQ, I have looked in the docs and don't find it.
Thanks in advance,
--Joan
--
Joan Armstrong joana@vcd.hp.com Hewlett Packard, Vancouver, WA. USA
Dogs: U-CD Copper Canyon's Belle Starr (Frannie) CD TD STDds PT JHD AX EAC OGC
EJC RSE JSO CGC; Wind Dance Nick of Time (Nick) TD NAC NGC NJC RSN RJN RGN
********************* In memory: Zoie wonder dog ****************************