Amit,

The obvious solution is of course if you could not try to modify the same
table more than once.
If this is not possible and you want/cannot revert to placing the inserts
into the trigger body itself, please open a PMR.

Cheers
Serge



"Amit Singal " <db2udbdba-ezmlmshield-x46540460.[Email address protected]
wrote on 09/29/2005 08:55:16 AM:

> Hi,
>
> We are facing problem while calling procedure multiple times from
Trigger.
> Procedure inserts a record in a single table. Following error is
encountered
> :
>
> SQL0723N An error occurred in a triggered SQL statement in trigger
> "DB2ADMIN.ZZZ". Information returned for the error includes SQLCODE
"-751",
> SQLSTATE " " and message tokens "DB2ADMIN.PROC|SQL050929172036500".
> SQLSTATE=09000
>
> Please suggest a way to call a procedure multple times to insert row(s).
>
> CREATE PROCEDURE proc ( )
> BEGIN
> insert into temp2(id)values(22);
> END
>
> CREATE TRIGGER DB2ADMIN.LOG_AU AFTER UPDATE OF ID, CDATE ON
DB2ADMIN.TEMP1
> FOR EACH ROW MODE DB2SQL BEGIN ATOMIC
> call proc();
> call proc();
> END;
>
> Regards
> Amit Singal
>
>
>
>
> ---------------------------------------------------------------------
> 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