FP11 will have a db2set registry variable to make away with -746 in
triggers. FP11 AFAIK is just around the corner

Cheers
Serge



"mmcnary" <db2udbdba-ezmlmshield-x13387489.[Email address protected] wrote
on 01/20/2006 10:58:00 AM:

> Your trigger and SP are both trying to access the same table. DB2 uses
> table access context rules to identify and resolve conflicts. There is
good
> explanation in DB2 SQL PL Essential Guide 2nd Ed, chapter 9 look for
figure
> 9.30.
>
> Thanx,
>
> Mark McNary
> NPPC MES Database support
> (w) 314-982-1389
> (m) 314-497-5850
>
>
>
>
> -----Original Message-----
> From: sourav
> [mailto:db2udbdba-ezmlmshield-x87799593.[Email address protected]
> Sent: Friday, January 20, 2006 12:01 AM
> To: LazyDBA Discussion
> Subject: Cursor in Trigger
>
>
>
> Hi All,
> when I'm tring to open a cursor within a trigger on after deletion, it
was
> giving a runtime error. Then I've tried to call a separate SP from the
> trigger, which should handle the cursor. But till I'm getting the
error.In
> that case the following error is given. Anyone can help me out?
>
> Information returned for the error includes SQLCODE "-746",
> SQLSTATE "57053" and message tokens
> "TL.USP_DELETE_TVACC|SQL060119220019726|READ". SQLSTATE=09000
>
> Thanks
> Sourav
>
> Notice: The information contained in this e-mail message and/or
attachments
> to it may contain confidential or privileged information. If you are
not
> the intended recipient, any dissemination, use, review, distribution,
> printing or copying of the information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If you have received
> this communication in error, please notify us by reply e-mail or
telephone
> and immediately and permanently delete the message and any attachments.
> Thank you
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


DB2 & UDB email list listserv db2-l LazyDBA home page