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