Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
TEXT fields
 Login/Join
 
Member
posted
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
 
Posts: 5 | Location: Westminster, CO | Registered: April 24, 2003Reply With QuoteReport This Post
<Melinda Nevotti>
posted
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?
 
Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 5 | Location: Westminster, CO | Registered: April 24, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 


Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.