473,513 Members | 2,601 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Objects dependency

Hi all

I would like to know whether DB2 get a command like Sybase's sp_depends.

Given a table, how could I know which stored procedures depend on the table?

Thanks a lot

Jack
Nov 12 '05 #1
2 4312
The sysibm.sysdependencies table records this information...for a stored
proc, only an SQL sp will know that it has this dependency.

Jack Ng wrote:
Hi all

I would like to know whether DB2 get a command like Sybase's sp_depends.

Given a table, how could I know which stored procedures depend on the table?

Thanks a lot

Jack

Nov 12 '05 #2
The sysibm.sysdependencies table records this information...for a stored
proc, only an SQL sp will know that it has this dependency.

Jack Ng wrote:
Hi all

I would like to know whether DB2 get a command like Sybase's sp_depends.

Given a table, how could I know which stored procedures depend on the table?

Thanks a lot

Jack

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
997
by: Nico Raddatz | last post by:
Hi all. I'm migrating a small app from vb6 to vb.net. It basically deals with invoices. This is the first time I do this kind of migration, from an existing app to a new one, the new app should be...
1
1540
by: baylor | last post by:
Are there are any best practices or guidance on how to share an object between the Web world and the non? Here's my situation: i have one object (a security profile containing IPrincipal + some...
25
5024
by: Stuart Hilditch | last post by:
Hi all, I am hoping that someone with some experience developing nTier apps can give me some advice here. I am writing an nTier web app that began with a Data Access Layer (DAL), Business...
3
7183
by: DJTN | last post by:
I'm getting the following error when I try to compile my setup project in VS 2002. I have re-installed the .net framework 1.1 and it didnt solve the problem. WARNING: Unable to find dependency...
3
2335
by: Smithers | last post by:
In Windows Forms MDI applications... I'm wondering if it is standard practice to create DAL and business objects as static classes. The only alternative (please enlighten me if I'm wrong about...
3
1787
by: Retep | last post by:
Hi all, hopefully someone can answer the following mystery for me: I have the following (simplified) application setup: Main Form | Form |
1
1543
by: Nemisis | last post by:
Hi everyone, If i have 3 objects as below. objectA A_id A_Name B_id objectB
0
1375
by: mseeger | last post by:
My concrete problem is this (it is a bit special, but there may be other instances of it): I'd like to create a class for vectors (say: Vector), exporting math. methods, say v.foo(...). I'd like...
4
5678
by: kellygreer1 | last post by:
Sometimes at the end of a project you'll end up with unused Tables, Stored Procs, Functions, and Views. Since there is not something like a 'SELECT' trigger ... what is the best way for telling...
0
7259
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
7380
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7535
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...
1
7098
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5683
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5085
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3221
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
798
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
455
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.