Definition of a view in DB2

Question

Is there any query/SQL Statement to see definition of a view in DB2?

I tried the following and it is resulting in an error as shown below

  SELECT * FROM SYSCAT.VIEWS

enter image description here

REFERENCE:

VERSION:

Test results based on How to check db2 version are listed below (for version)

enter image description here

See here: http://stackoverflow.com/questions/3821795/how-to-check-db2-version — , Jan 08 '13 at 12:07
@a_horse_with_no_name Thanks. The question is updated with `Version` information — LCJ, Jan 08 '13 at 13:03

score 3 · Accepted Answer · answered Jan 08 '13 at 14:51

If you have admin permissions to the database, you can use the db2look utility:

db2look.exe -i your_userid -w your_password -d your_database -e -t your_table

Change the variables that start with your_.

If that doesn't work for you, you should be able to do:

SELECT TEXT
FROM SYSIBM.SYSVIEWS

If your platform (I can't see your picture for some reason) is the Mainframe DB2 (z/OS), then be aware that the catalog view will only show a part of the definition, if it's very long, it'll be cut off (on mine, z/OS v9.1, it only shows the first 1500 characters of the definition).

Thanks. SysIBM Helped -- SELECT * FROM SYSIBM.SYSVIEWS WHERE NAME LIKE '%V1_NID%' AND CREATOR = 'ABASC' — LCJ, Jan 09 '13 at 09:54

score 0 · Answer 2 · edited Oct 26 '18 at 04:28

0

select name, cast(text as varchar(8000))
from SYSIBM.SYSVIEWS
where name='your table name'

In statement is the view-definition...

edited Oct 26 '18 at 04:28

chanchal1987

2,320
7
31
64

answered Jun 25 '14 at 09:33

nesmoht

125
8

do try to add some details to support your answer. see [answer] – pushpraj Jun 25 '14 at 09:56

score 0 · Answer 3 · answered Sep 23 '16 at 11:46

0

      select name, cast(text as varchar(10000))
      from SYSIBM.SYSVIEWS
      where name='YourVIEW'

answered Sep 23 '16 at 11:46

Gokuldas.Palapatta

72
8

Definition of a view in DB2

3 Answers3