
	Home > Ask the AS/400 Experts > Questions & Answers > Storing XML data in a CLOB field

Ask The iSeries 400 Expert: Questions & Answers

EMAIL THIS

Storing XML data in a CLOB field

EXPERT RESPONSE FROM: Kent Milligan

		Pose a Question

		Other iSeries 400 Categories

		Meet all iSeries 400 Experts
		Become an Expert for this site

Digg This!

StumbleUpon

Del.icio.us

QUESTION POSED ON: 23 August 2007
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.

EXPERT RESPONSE

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.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	iSeries Applications
	System i no longer the stepchild of IBM's world
	IBM System i gets VoIP via Nortel
	Top 10 System i white papers
	Fast Guide to System i/iSeries book excerpts
	Top System i admin tips for 2006
	System i software wrap
	Red Wing finds that Intentia-Lawson merger fits just right
	System i5 Solutions For Business Resiliency
	IBM configures iSeries to jibe with JD Edwards ERP apps
	Blyth profits from business intelligence software
	iSeries Applications Research

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

iSeries Networking - Printing, Remote Access, TCP/IP

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 1999 - 2008, TechTarget \| Read our Privacy Policy