who calls procedures
Hi, I was trying to find if any of the triggers in the database calls a particular stored procedure. I 'select data from systrigbody' to a file and look for the name of the procedure. Is there a better way to do this.(Since the output has non readable text as well) TIA Sathish Sadagopan
In article <7831tu$7t2$1@news.xmission.com>,
"Sadagopan, Sathish, CFCTR" <sadagop0458@att.com> wrote:
>
> Hi,
Hi Satish,
> I was trying to find if any of the triggers in the database calls a
> particular stored procedure.
> I 'select data from systrigbody' to a file and look for the name of the
> procedure.
> Is there a better way to do this.(Since the output has non readable text as
> well)
Try the following :
select data from systrigbody where datakey = 'A'
The data is still not very readable (it has tabs, spaces etc.) but
is bearable.
> TIA
> Sathish Sadagopan
>
Regards,
Ravi...
--
Ravi Pinto, Bombay, India.
mailto:ravipinto@my-dejanews.com
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Sadagopan, Sathish, CFCTR wrote:
>
> Hi,
> I was trying to find if any of the triggers in the database calls a
> particular stored procedure.
> I 'select data from systrigbody' to a file and look for the name of the
> procedure.
> Is there a better way to do this.(Since the output has non readable text as
> well)
> TIA
> Sathish Sadagopan
Try the dbschema utility: dbschema -d <database>
If you are on a unix system, redirect its output to a file or pipe it to
less, then search for the name of your stored procedure.
Bye...
Dirk
In article <7831tu$7t2$1@news.xmission.com>,
"Sadagopan, Sathish, CFCTR" <sadagop0458@att.com> wrote:
>
> Hi,
> I was trying to find if any of the triggers in the database calls a
> particular stored procedure.
> I 'select data from systrigbody' to a file and look for the name of the
> procedure.
> Is there a better way to do this.(Since the output has non readable text as
> well)
> TIA
> Sathish Sadagopan
>
procedure name is "ins_thistable"
Try this:
select trigname
from systriggers st, systrigbody stb
where st.trigid = stb.trigid
and stb.datakey = 'A'
and stb.data matches '*execute procedure "*".ins_thistable*';
Bob
---------
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own