Ask the Expert

Storing XML data in a CLOB field

I would like to store XML data in a CLOB field. Is there any way to see the values of the CLOB field? All I see is *POINTER when I select the field using SQL.

Yes, your application would need to fetch the data out of CLOB column into an application variable. There are some LOB programming examples in one of the IBM Redbooks titled DB2 UDB for AS/400 Object Relational Support at ibm.com/redbooks.

In terms of integrating DB2 and XML data, I'd also highly suggest getting the following book from ibm.com/redbooks: The Ins and Out of XML and DB2 for i5/OS.

This was first published in August 2007

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: