Trigger and Call results in the 57053 problem but why?

[tomtailor]

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

[Serge Rielau]

to*******@freesurf.fr wrote:

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

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

[tomtailor]

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

[Serge Rielau]

to*******@freesurf.fr wrote:

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..

There is no difference between functions and procedures with that respect.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab