Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
DAVID HIVERT — — source: IIUG Forums & Mailing Lists
Hi Folks,
I'm trying to obtain the records of the ph_task table in sysadmin db into an
ODBC app. I've noticed that interval year to date fields in this table were
the origin of the errors encountered.
For example you can test it with the Connect Test Demo with the SQL Script
"Select tk_delete from ph_task" returning "Unkown SQL Type -110".
I thougth it was possible to escape from the error with a view based on the
table with converted types, but i can't imagine that the data types are not
supported by client odbc apps.
Any idea ?
Using IDS 11.50.TC9 on WinServer2003 and Informix Connect 3.70 on 7/32 Client.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.