|
View previous topic :: View next topic
|
| Author |
Message |
surya.kalyan
New User
Joined: 09 Jan 2007
Posts: 20
Location: Mumbai
|
|
|
|
Is it possible to view the definition of a view after it has been created from some catalog tables given its name??
I checked the sysibm.sysviews table and it seems that it stores the definition of the view but I was not able to get a meaningful definition.
Please give the query if possible. |
|
| Back to top |
|
 |
wanderer
Active User
Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka
|
|
|
|
| There is no query you can run to get the DDL. The best way is to use some third party tool like BMC or CA or even IBM. |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| wanderer wrote: |
| There is no query you can run to get the DDL. The best way is to use some third party tool like BMC or CA or even IBM. |
It is in sysibm.sysviews the field TEST. Select all the rows where NAME is equal to the view you are looking for and order by seqno. |
|
| Back to top |
|
|
wanderer
Active User
Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka
|
|
|
|
| My mistake. Yes, that is correct. Thanks Craq! |
|
| Back to top |
|
|
catchyblues
New User
Joined: 28 Dec 2005
Posts: 24
|
|
|
|
| Select text from Sysibm.sysviews where name = 'table-name' |
|
| Back to top |
|
|
|
|
