XML format of records in db2 tables

ggnanaraj · #1 (**permalink**) 11-07-03, 08:52

Do we have a function or any tool to convert records of a table in DB2 into XML format?

TIA

sathyaram_s · #2 (**permalink**) 11-07-03, 09:24

XML Extender

On V8, it is packaged with the database ..

In earlier versions, you will find this on a seperate CD

Cheers
Sathyaram

Quote:

Originally posted by ggnanaraj
Do we have a function or any tool to convert records of a table in DB2 into XML format?

TIA

ggnanaraj · #3 (**permalink**) 11-07-03, 23:44

Hi

Thanks for the input.

Would you be able to give the steps to get the XML format of all records in a table?

I'm looking for something like... for eg., to spool the following query to a file...assumming that there is a xml function...any pointers should be helpful.

Code:

select xml(empno, empname) from emp

TIA.

sathyaram_s · #4 (**permalink**) 11-08-03, 05:07

I'd suggest that you visit the IBM website and read a user-guide to understand what can be done and cannot ...

Cheers
Sathyaram

Quote:

Originally posted by ggnanaraj
Hi

Thanks for the input.

Would you be able to give the steps to get the XML format of all records in a table?

I'm looking for something like... for eg., to spool the following query to a file...assumming that there is a xml function...any pointers should be helpful.

Code:

select xml(empno, empname) from emp

TIA.

Internet Services

Web Development

Digital Marketing

Consumer Tech