View previous topic :: View next topic
|
Author |
Message |
javvajiram
New User
Joined: 26 Nov 2007 Posts: 4 Location: chennai
|
|
|
|
We have a requirement to UNLOAD Normal data(which is not in XML format) from DB2 tables into file in XML foramt using UNLOAD utility.
Is there any feature for UNLOAD utility to directly unload normal data into XML format ?
I have referred many sites but couldn't find any clue.
Can any one help me in this regard.
Thanks in advance. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
why don't you look at the UNLOAD utility's documentation? |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
don't think unload will help you here .
you might try something with dsntiaul
and a sql statement like :
if total length < 32K
Code: |
select xmlagg(xmlelement(NAME "ROW",xmlforest(name as xnam,creator as xcrea,dbid as xdbid))) from sysibm.sysdatabase a |
else
Code: |
select xmlelement(NAME "ROW",xmlforest(name as xnam,creator as xcrea,dbid as xdbid)) from sysibm.sysdatabase a |
you probably need some dfsort or idcams manipulation afterwards |
|
Back to top |
|
|
javvajiram
New User
Joined: 26 Nov 2007 Posts: 4 Location: chennai
|
|
|
|
Thanks a lot for your quick reply. |
|
Back to top |
|
|
|