By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,672 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

Trigger and Call results in the 57053 problem but why?

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
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
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.