Identifying XML type columns



IBM's flagship relational database management system

Identifying XML type columns

Postby kk12345 » Thu Jan 06, 2011 8:20 pm

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.
kk12345
 
Posts: 18
Joined: Sun Dec 26, 2010 6:26 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Identifying XML type columns

Postby enrico-sorichetti » Thu Jan 06, 2011 9:20 pm

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!
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post