Find view's definition in DB2.

[LearnMainframe]

Hi,

Does someone know of a possible way to find the definition of a view? I did check in the sysibm.sysviews table and there I was not able to get a meaningful definition.

[nicc]

Find the program/SELECT that creates the view.

[Akatsukami]

What information are you seeking?

[LearnMainframe]

I need to know the DDL for the view and the description of the columns used in the view definition.

[LearnMainframe]

This SQL query has worked for me:

Code: Select all

SELECT * FROM SYSIBM.SYSVIEWS 
WHERE NAME LIKE '%Z4_UID%' 
AND     CREATOR = 'CAPN'