Hello!

I have 2 Stored Procedures and want to call them out of a Trigger. I
know that I'm not able to access Tables witch are part of the
Trigger-Query so I do not.

My Trigger is:
Create Trigger .SKURS_ADEL after delete on SKURS referencing old as old
for each row mode db2sql
begin atomic
call setSteigung(old.ident,old.datum);
call setAVG(old.ident, old.datum);
end

the procedures only uses table param and kurs but NOT skurs, so why is
there the 57053 SQLState if I delete some Rows??

THX!

Christian Meier

tomtailor@freesurf.fr wrote:[color=blue]
> Hello!
>
> I have 2 Stored Procedures and want to call them out of a Trigger. I
> know that I'm not able to access Tables witch are part of the
> Trigger-Query so I do not.
>
> My Trigger is:
> Create Trigger .SKURS_ADEL after delete on SKURS referencing old as old
> for each row mode db2sql
> begin atomic
> call setSteigung(old.ident,old.datum);
> call setAVG(old.ident, old.datum);
> end
>
> the procedures only uses table param and kurs but NOT skurs, so why is
> there the 57053 SQLState if I delete some Rows??
>
> THX!
>
> Christian Meier
>[/color]
Could there be a conflict between two CALLs? The 57053 is very - ehem -
trigger happy.
We are working to get rid of it for good. *yeah*
If you are willing to a beta tester please open a PMR

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

I tried to comment the 2nd Call but trigger stil fails. I read an
update on a cupple of tables but not the skurs table.

Now I try to make Functions instead of Procedures and make the updates
in the trigger it self. mabe it results in less performence but i
should work..

Cheers
Christian

tomtailor@freesurf.fr wrote:[color=blue]
> I tried to comment the 2nd Call but trigger stil fails. I read an
> update on a cupple of tables but not the skurs table.
>
> Now I try to make Functions instead of Procedures and make the updates
> in the trigger it self. mabe it results in less performence but i
> should work..[/color]
There is no difference between functions and procedures with that respect.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab