UDB V8.1 Feature

dharmadam

I would like to store the select statement values in to a table by
using the SELECT FROM INSERT. For example,

insert into taddress_next
(select beneficiary_id,address_line1_tx from
NEW TABLE (
insert into qcpi039.taddress_benes (
beneficiary_id,address_line1_tx)
values
(12345632,'NewAddress')
))

It doesn't work. Is it possible to do this in V8.1

Nov 12 '05 #1

Serge Rielau

Couple of small changes:

WITH I1 AS (select beneficiary_id,address_line1_tx from
NEW TABLE (
insert into qcpi039.taddress_benes (
beneficiary_id,address_line1_tx)
values
(12345632,'NewAddress'))
select count(1) FROM
NEW TABLE(insert into taddress_next
select beneficiary_id,address_line1_tx
from i1

Background:
To avoid read/write conflict issues DB2 forces series of
updates/inserts/deletes to be sorted using WITH.
Since WITH is in DB2 only allowed as part of select statement
you need to add this outer SELECT.

Cheers
Serge

Nov 12 '05 #2

Serge Rielau

PS: I also sent you a presentation on that topic by email.

Cheers
Serge

Nov 12 '05 #3

Gert van der Kooij

In article <2s*************@uni-berlin.de>, Serge Rielau
(sr*****@ca.ibm.com) says...

PS: I also sent you a presentation on that topic by email.

Cheers
Serge

I'm also interested in your presentation. Cna we also find it on the
Developers Domain or another website.

TIA.

Nov 12 '05 #4

Serge Rielau

I have long meant to turn the presentation into a developer domain
article, but I kept getting pre-empted
If you send me an email I'll fire back the presentation.

Cheers
Serge

Nov 12 '05 #5

Serge Rielau

Pierre, you're address is bouncing...

Nov 12 '05 #6

dharmadam

Serge Rielau <sr*****@ca.ibm.com> wrote in message news:<2s*************@uni-berlin.de>...

Pierre, you're address is bouncing...

Serge,
Thanks for the help. Please send the doc to su****@aol.com

Nov 12 '05 #7