Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > db2 > answers

Viewing the SQL behind a View in 9.5

Newbie
  
Join Date: Aug 2009
Posts: 1
#1: Aug 18 '09
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's Avatar
Newbie
  
Join Date: Aug 2009
Location: UK
Posts: 22
#2: Aug 19 '09

re: Viewing the SQL behind a View in 9.5

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/infoce.../r0001068.html

Cheers

Vijay
Reply

« previous question | next question »

Similar DB2 Database bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,295 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved