When using native SQL, you cannot use distinct or order by on XML columns in DB2.
Using TOAD, you can sort the resulting data in the results window by clicking on the header of the XML column. This helped solve a problem to find duplicate records easily.
I was wondering if there any trick / workaround to create a filter of “distinct” on a table containing XML results.
Usually, I need the distinct only on some of the fields, so I could create a sub-query using distinct, but I have never gotten the hong of using sub-queries from the query builder window.