|Subject||Re: [IB-Architect] SQL Statement Depandance Mapping|
> I'm not really interested in dependencies between objects with in theTake this as a workaround
> database (tables, SPs, etc). What I am interested in is the
> dependencies of
> embedded or dynamic SQL (SELECT, UPDATE, DELETE). The query engine
> discover these dependencies the first time the statement is prepared.
> data from the query engine could be used to build dependency maps.
Let DMLQ a DML query. (your query)
Let DMLQSP a SP with DMLQ, in this form:
Create Procedure DMLQSP
Now you can select the desired dependents from your DMLQ through
Select ... from rdb$dependents where ...name = "DMLQSP"
So, I feel the query engine has all you need to discover dependents of a
DML query, but my workaround is not very "automatic" :(
So, there is a need for a new API call in order to the query engine
inform you the dependents, as much as the API call to retrieve the query
[I think query plan is very different to query dependents]
If this API call exists, some tools that displays query plans, can then
display the query dependants. I don't know if this is very important, I
never fell the necesity to use such a functionality, but I feel that
this is not a lot of work (imho), is only a new API call based on
existing query engine functionality. And this API call is similar to
plan API call (imho).
You have my vote for this new API call ;)
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.