Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
See Aquaclusters case 316 for more details.
In IBM Data Studio we used to see the XML column data from a select query and were able to open the XML data in a separate XML document. A user asks how to read XML column data on Aqua Studio. In Aqua Studio all XML data from the column are displayed as some JCC driver static text.
|
|
13 KB
|
|
25 KB
|
|
151 KB
|
|
27 KB
|
|
131 KB
|
|
9 KB
|
|
145 KB
Customer is using DB2 z/OS.
Suggested using work arounds:
SELECT XMLCAST((SELECT "c1" FROM TOM.TOMXML) AS VARCHAR(1000)) FROM TOM.TOMXML
and
SELECT XMLSERIALIZE((SELECT "c1" FROM TOM.TOMXML) AS CLOB(1000)) FROM SYSIBM.SYSDUMMY1
They can save the file as an XML document and view it using an XML editor. Probably not what they want but suggest it anyway.
Issue #15878 |
| New |
Completion |
| No due date |
| No fixed build |
| No time estimate |
Customer is using DB2 z/OS.
Suggested using work arounds:
SELECT XMLCAST((SELECT "c1" FROM TOM.TOMXML) AS VARCHAR(1000)) FROM TOM.TOMXML
and
SELECT XMLSERIALIZE((SELECT "c1" FROM TOM.TOMXML) AS CLOB(1000)) FROM SYSIBM.SYSDUMMY1
They can save the file as an XML document and view it using an XML editor. Probably not what they want but suggest it anyway.