I'm trying to read a TEXT field from a Sybase table into a hold file and I'm having trouble with a clean read. I'm wondering if anyone has been able to read successfully a TEXT field from Sybase, Oracle or Microsoft SQL Server?

Thanks... Simon

Hi Simon,

We read TEXT fields from Oracle, but we define them in Oracle as Varchar2(xx). xx = is the length of the text field. In the MFD we define them as USAGE=A60, ACTUAL=A60 for a 60 character field.

Does this help?

Melinda, unfortunately this does not help. Nevertheless, thank you!

I was referring to a field of type TEXT, similar to BLOB but it holds text data upto 2Gb. We're storing documents in this TEXT field and I'm trying to retrieve them into a hold file and parse the hold file.

Unfortunately, I've been plagued with issues and so I was hoping to see if I could leverage someone's experience in this area.

Thanks! Simon