473,480 Members | 4,852 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Viewing the SQL behind a View in 9.5

1 New Member
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.
Aug 18 '09 #1
1 4164
vijay2082
112 New Member
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
Aug 19 '09 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
3600
by: Neil Morris | last post by:
Hi I was wondering if there was a way to view the html code that javascript produced since viewing the source code shows the javascript if statements for netcrape and IE etc. thanks Neil...
1
1424
by: Jonathan Taylor | last post by:
I have a large XML file that contains many complex objects. The objects contain a fairly sizeable amount of information and I'm only interested in displaying the name of each item. I don't want...
2
1559
by: Mark Fox | last post by:
Hello, In VS.NET 2003 when I add server controls to the web form it sometimes adds their declarations to the code behind and sometimes not. Is there a way to tell VS.NET to parse the web form...
1
1365
by: z. f. | last post by:
Hi, adding a control with runat=server to an aspx page (using code - not designer view) - don't cause the control to be added to the code behind (.cs ot .vb file) only if i change the aspx...
2
1951
by: Matthias H. | last post by:
Hi guys, Our team has a very strange problem. I hope anybody can help. We have a class called webpage and all our aspx-pages bases on it. Then we have a SYS.IO.File Class which have a...
6
5474
by: Paolo Pignatelli | last post by:
I have an aspx code behind page that goes something like this in the HTML view: <asp:HyperLink id=HyperLink1 runat="server" NavigateUrl='<%#"mailto:" &amp;...
3
1812
by: Brooke | last post by:
How can I prevent a user from viewing the html code on a web page? e.g. right click->view source
10
1507
by: David Lee Conley | last post by:
When I open the Data Sources window and create a new data source, everything works fine. But if I have a form showing in the IDE, the Data Sources window becomes disabled and doesn't display any...
0
1406
by: Deceneu | last post by:
Hi everyone, this is my first post so please bear with me. I have the following situation: i have a local report that needs to have two "versions": one for viewing in the report viewer (with all...
0
7040
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
6905
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7080
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
6908
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
4478
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
2994
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
2980
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
561
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
178
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.