I have created an table 'TABLE' in DB2 :
PID INTEGER 4 No
DATEUPDATE DATE 4 No
CLINICINFO XML 0 Yes.
In the above table the CLINICINFO has XML content of userdefined ...
When i used SQL Call bulider to the statment "SELECT * from TABLE".
'xml' content data value is displayed as null ...
How can i get the xml (CLINICINFO) content as an data along with other two fields into the portlet (Using WebSphere Portlet Factory) ...
Pinned topic Need for Accessing XML Datatype from a table in DB2 to Portlet - Using WPF
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2010-05-20T09:16:06Z at 2010-05-20T09:16:06Z by SystemAdmin
DGawron 10000054HC251 Posts
Re: Need for Accessing XML Datatype from a table in DB2 to Portlet - Using WPF2010-05-18T13:14:03ZThis is the accepted answer. This is the accepted answer.XML columns are handled like LOBs by DB2. By default SQL Call omits LOB columns from the result sets it generates. To have SQL Call include the XML column in its result set you'll need to either convert the XML column's value into a VARCHAR (using the XMLSERIALIZE scalar function) or you'll need to use a custom transform method that adds the column's value into the result set in some meaningful way. The forum contains a number of posts around creating and using custom transforms.
The XML schema automatically generated for the result set will not cover the XML in the column since SQL Call has no visibility into the content of the column. Depending upon how the data from this column is used this may or may not be a problem. If you intend to display the column's XML using page automation, then you'll need to define a schema for the content.
SystemAdmin 110000D4XK532 Posts
Re: Need for Accessing XML Datatype from a table in DB2 to Portlet - Using WPF2010-05-20T09:16:06ZThis is the accepted answer. This is the accepted answer.
- DGawron 10000054HC