Does anyone have any information about using CLOB data types with LiveReports? ...

Does anyone have any information about using CLOB data types with LiveReports? I am trying to retrieve data from multiline attribute (defined as CLOB in table) in LiveReport but don't know how to get that?

Find more posts tagged with

Comments

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

From what I recall, CLOB datatypes support string functions such as SUBSTR. Have you tried a SUBSTR function?

- Bhupinder----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, July 27, 2009 12:51 PM
To: eLink Recipient
Subject: Does anyone have any information about using CLOB data types with LiveReports? ...

Does anyone have any information about using CLOB data types with LiveReports? ...

Posted by kamin@enmax.com (Amin, K) on 2009/07/27 12:48

Does anyone have any information about using CLOB data types with LiveReports?

I am trying to retrieve data from multiline attribute (defined as CLOB in table) in LiveReport but don't know how to get that?

K_A

I did but didn't work. how you will change the d.VALSTR in the following SQL:select distinct b.valstr, c.valstr, d.VALSTR from LLAttrData b, LLAttrData c, LLAttrData d, DTree t where (t.DataID=b.ID and b.DefID=49081 and b.AttrID=3 and t.VersionNum=b.VerNum) and(t.DataID=c.ID and c.DefID=49081 and c.AttrID=5 and t.VersionNum=c.VerNum) and(t.DataID=d.ID and d.DefID=49081 and d.AttrID=6 and t.VersionNum=d.VerNum)

Tim_Hunter

d.valstr isnt a clobWhat are you trying to get from this?