----- Original Message -----
From: Jason Chapman (JAC2)
Newsgroups: egroups.ib-support
To: ib-support@yahoogroups.com
Sent: Monday, January 27, 2003 1:06 PM
Subject: Re: [ib-support] Re: Metadata SP order extraction problem


You can:
1) Create all procedures with headers but empty bodies.
2) The use alter procedure to fill in the bodies and create the
dependencies.

Without doing it this way you can never have procedure calling 1 which calls
2 which sometimes calls 1 again.

JAC.


""PlusPoint Sofware SA"" <info@...> wrote in message
news:005a01c2c5e2$7fb82310$010101c2@stationnet...
> In fact, you need to read all the dependencies from all the SP to know
wich one call another one ...
> To drop all SP you need first to drop the calling procedures.
> To create all SP you need first to create the called procedures.
> All those infos are into de DB$ system table.
> I've made a module calculating order to drop and create script in correct
creation order.
> That's all
> Georges




Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]