IBM Mainframe Forum

Hi All,

I like to identify the columns of type XML in my real time system.
How to get this information from SYSIBM tables ?

I read the manual and understood the basics of the XML datatype. but I like to see the real-time examples as well.

will be waiting for your kind response.

the general approach would be
select <all You might want to know> from <the appropriate SYSIBM.table> where <some condition>

now...
a bit of reverse engineering
select * from SYSIBM.SYSCOLUMNS where name=< a column that You know to be an XML type>

after that having identified what to put into the COLUMN<type> the rest should be easy!