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

Session tables in triggers. Is it planned?

P: n/a
Hello.

I see, that even in V9 they are not supported.
Question to IBM:
Is this functionality planned in future?
They are supported in iSeries and I think it's very convenient...

Sincerely,
Mark B.

Sep 20 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
4.****@mail.ru wrote:
I see, that even in V9 they are not supported.
Question to IBM:
Is this functionality planned in future?
They are supported in iSeries and I think it's very convenient...
You can push the body of a trigger into a stored procedure and use them
there. Are you asking for DECLARE'd or CREATEed temp tables in triggers.
The headache about DGTT is that they aren't cataloged.
If DB2 for LUW were to support CGTT (Created) then they woudl be allowed
in the trigger body directly.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 20 '06 #2

P: n/a
Actually, the problem is that I want to copy content of transition
table into session table for futher processing. The goal is
performance.
How can I do this?
Only by calling some procedure in cycle for each row (bad performance i
think for 1 million row insert)?
Is there another way?
You can push the body of a trigger into a stored procedure and use them
there. Are you asking for DECLARE'd or CREATEed temp tables in triggers.
The headache about DGTT is that they aren't cataloged.
If DB2 for LUW were to support CGTT (Created) then they woudl be allowed
in the trigger body directly.
Sep 21 '06 #3

P: n/a
4.****@mail.ru wrote:
Actually, the problem is that I want to copy content of transition
table into session table for futher processing. The goal is
performance.
How can I do this?
Only by calling some procedure in cycle for each row (bad performance i
think for 1 million row insert)?
Is there another way?
You could privatize a persistent table. E.g. use GENERATE_UNIQUE() or a
SEQUENCE to get a ticket. At the end of the trigger DELETE.
Since the trigger is atomic you don't even need to worry about cleanup.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 21 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.