I am trying to print a CLOB field from an Informix table. Its synonym is " FIELDNAME=LO_COMMENT, ALIAS=lo_comment, USAGE=TX50, ACTUAL=TX, MISSING=ON, $"
It is the last field in a one segment, 3 key field table.

It will print from the Dev Studio Command Console, but not from a fex.
TABLE FILE CASE_PERSON_DISPO
PRINT LO_COMMENT
WHERE CASE_ID IN (1959456, 870444, 662917, 878688, 1958556 )
BY CASE_ID
END
prints properly from the Web Console. But if I take the exact same code and run from a fex, I get "(FOC1133) INTERNAL ERROR IN DATA CONVERSION ROUTINES : (09,06)/000035" for each record.

Any Informix users out there? I would appreciate help.

Mary Rich

This message has been edited. Last edited by: <Kathryn Henning>,

Have you checked your APP PATH or WHENCE?

Maybe there are multiple copies of your master file and the what the Console is "seeing" may not be the same your .fex is.

That was my first thought as well.

We found an answer thru Informix. It has special functions to work with "Smart Objects" (BLOBs and CLOBs). LOTOFILE(...) unloads the CLOB to s flat file in .txt format ... which then is easy to work with.

PS: MY App Path and Whence were identical ... thx for you help.