Viewing the SQL behind a View in 9.5

[adamsom69]

Hi

I have a defined view in DB2 version 9.5, but have no source code anywhere on the server telling me the details of the SQL behind the view. How, within the DB2 Control Centre can I view the SQL Code that defines this view.

Thanks in advance.

[vijay2082]

open control centre > connect to the database > Views > select and right click on view ..click Alter ........you will see the SQL Statement

Alternatively select text column from syscat.views catalog view.

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0001068.html

Cheers

Vijay