473,327 Members | 2,112 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

List the dependency of a object

Hi all

I would like to know whether DB2 get a command like sybase sp_depends.
For example, I need to drop a table. How can I know which stored
procedures depend on the table?

Thanks a lot

Jack
Nov 12 '05 #1
2 5591
Check out the view SYSCAT.ROUTINEDEP and SYSCAT.PACKAGEDEP.
I keep forgetting whether an SQL Procedure directly record dependencies
or makes a hop through PACKAGEDEP.
Easy enough to figure out though.

Another way to do it is to download Stinger and smooch the dependency
function used by the GUI. It's written in SQL.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2
Check out the view SYSCAT.ROUTINEDEP and SYSCAT.PACKAGEDEP.
I keep forgetting whether an SQL Procedure directly record dependencies
or makes a hop through PACKAGEDEP.
Easy enough to figure out though.

Another way to do it is to download Stinger and smooch the dependency
function used by the GUI. It's written in SQL.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #3

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

Similar topics

1
by: Qin Chen | last post by:
I will present very long code, hope someone will read it all, and teach me something like tom_usenet. This question comes to me when i read <<Think in C++>> 2nd, chapter 10 , name control,...
5
by: didier Belot | last post by:
Hi! If the subject isn't clear: Modern browsers provide an optional way of remembering user input in textbox: user begin to type, and a list drop down just under the textbox showing matching...
4
by: Henke | last post by:
I have this scenario. public class A { public int numbers; public class A() { }
1
by: Rimma Meital via .NET 247 | last post by:
(Type your message here) -------------------------------- From: Rimma Meital I have 2 DLLs (Class Libraries). Both defines single-ton objects - logger object (writes to logger) and...
2
by: wh | last post by:
I'm not sure what I am trying to do is correct but within a global object I'd like to store an object with a dependency on a specified directory. I am aware that I am able to add a reference to a...
1
by: msnews.microsoft.com | last post by:
I'd like to hear your thoughts on best methods for populating drop down list controls. I have states and countries drop down lists that don't change often, so naturally I "hard code" them in the...
2
by: Darryl | last post by:
I'm working on converting an A97 DB that someone else wrote to A2K3. It's converted fine, as far as I can see. Now while making changes, I've removed several buttons on a form that called...
35
by: Thierry Loiseau | last post by:
Hello all, and Happy end year 2005 ! Well, I would like to obtain a list of all JavaScript var statement, With "for...in" perharps ? That is bellow my recent test here, but the problem is...
7
by: dev_15 | last post by:
Hi, just a simple question in an OO design in C++ if i am using composition to model a relationship i would have the object as a member(or pointer member) of the class ie class Airport {...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.