Is there a function in DV to convert the results of a SQL query to an XML document?
Environment
- Red Hat JBoss Data Virtualization (DV) 6.1
Issue
- Is there generic function to generate XML document without explicitly indicating any XML tags?
For example:
select customer_id, first_name, last_name, street from customer
should return
<customers>
<customer>
<customer_id>1</customer_id>
<first_name>John</first_name>
<last_name>Smith</last_name>
</customer>
....
</customers>
Resolution
No DV does not contain a function to convert SQL results to an XML Document, a User Defined Function would need to be created for this functionality.
This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
