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...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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.

Related Resources

Resolving key integration challenges for financial applications –SearchFinancialApplications
The Right Strategy for CFOs to Navigate Financial Application Purchases –SearchFinancialApplications
How You can Push I/O Processing Through the Roof for All Applications –DataCore Software Corporation
Protecting your Business and its' Data: Backup vs. Disaster Recovery –iLand

Fast Guide to System i/iSeries book excerpts

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our AS/400 experts

View all AS/400 questions and answers

Tips for installing Lotus Domino server on a System i partition

IBM System i gets VoIP via Nortel

Fast Guide to System i/iSeries book excerpts

System i shop retires legacy app, starts fresh

IBM System i gets VoIP via Nortel

System i shop retires legacy app, starts fresh

System i software wrap

Red Wing finds that Intentia-Lawson merger fits just right

Fast Guide to System i/iSeries book excerpts

Tips for installing Lotus Domino server on a System i partition

Status messages with the CEEMOUT API -- part 2

Status messages with the CEEMOUT API -- part 1

APIs and exit programs: Thousands of lines of free code

Please create a username to comment.

Converged data center migration practices to avoid data loss

14 SIEM reports and alerts to boost security

IBM Power9 servers add reliability, reduce maintenance costs

Related Resources

Dig Deeper on iSeries Applications

Related Q&A from Kent Milligan

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.