Topic
  • 1 reply
  • Latest Post - ‏2009-10-07T04:19:02Z by bsilverm@us.ibm.com
p_romanus
p_romanus
1 Post

Pinned topic How do I retrieve free text field fields from ClearQuest, CLOB, BLOB?

‏2009-10-06T09:53:59Z |
Hi, how do I retrieve free text fields from the datasources.

E.g
To return the 'Description' field from CQ:
> I specify a CLOB SQL Type as the data type in the XML Data Configuration
> Framework manager then appears to pick this up as a 'Binary' type - not looking good
> If I test the field in Framework manager - no errors - but nothing is retrieved for the 'Description' field.

If VARCHAR is selected - it naturally truncates the output - not what we need.

Please help

Paul
Updated on 2009-10-07T04:19:02Z at 2009-10-07T04:19:02Z by bsilverm@us.ibm.com
  • bsilverm@us.ibm.com
    bsilverm@us.ibm.com
    2 Posts

    Re: How do I retrieve free text field fields from ClearQuest, CLOB, BLOB?

    ‏2009-10-07T04:19:02Z  
    Hi Paul,

    Which field are you looking for? Is this a field in CQ that you can see when you browse the DataServices? For example, going to http://<server>:9080/DataServices/ClearQuest/ will show the DB's and display names. Let me know if there is a specific field you are trying to get to and I will have a look. Thanks,