Can any one plz help me to know the description of the view in DB2.. Ie.., i wanna to know what are all the tables related in that particular view. I tried with SYSIBM.SYSVIEWS and other tables but it shows only.

Create view viewname where (............)

but i wanna the description of that view.. Can any one help me. ThX in Adv.

I cant get u what u r trying to say... but meanwhile i got the solution. ie., i was checking in SPUFI env. once i tried the SELECT option of SYSIBM.SYSVIEWS on QMF i got the result what i expected. Hope u r saying in alternative way. Plz give in detail let us all know more about that.