SEO

#1 (**permalink**) 02-27-2008, 08:16 AM

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.

#2 (**permalink**) 02-27-2008, 08:16 AM

4.spam@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/

#3 (**permalink**) 02-27-2008, 08:16 AM

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

#4 (**permalink**) 02-27-2008, 08:17 AM

4.spam@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/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Session tables in triggers. Is it planned?