Subject:Empty Columns Not Seen when Using the XQuery Mapper Author:David Harris Date:19 Jul 2006 03:32 PM
When using the XQuery Mapping feature to an Oracle data source, only columns in the database which have values appear in the mapper on the left; empty columns don't appear. Is there a way to see all columns, regardless of whether they have a value or not in the database?
Subject:Empty Columns Not Seen when Using the XQuery Mapper Author:Ivan Pedruzzi Date:20 Jul 2006 06:47 PM
Unfortunately the mapping tool in build 501 uses the table data to populate the tree.
To workaround the problem you could create a simple XML document that reproduces the table structure then use the document for design the the query using mapper, when you are done you can replace the call to the document function with a call to collection. Be sure to have the collection defined in the scemario dialog and to run your query with the DataDirect XQuery processor.