Cant you do a insert from the select with the where clause in the select
has an in(1005024,1005025 etc)
so insert into tablex (col1, col2) (select col1, col2 where colx in
(1005024, etc)






"Das Ashim K " <db2udbdba-ezmlmshield-x90678861.[Email address protected]
03/20/2008 03:53 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Multi Table Inserts in DB2








Hi,
DOES DB2 support the Multi Table insert syntax like the following
statement from Oracle 9i. If not what is the best way to do this with
out doing 7 separate insert statements.

Thanks,
Ashim
--------------------------------------------------------------------

INSERT ALL
WHEN flex_value_set_id = 1005023 THEN
INTO
FDW.GL_SEGMENT_VAL_HIERARCHY_new(SEGMENT_ID,SEGMENT_NAME,CHILD_SEGMENT_V
ALUE,PARENT_SEGMENT_VALUE,PARENT_CHILD_FLAG,CREATE_DATE)VALUES(1,'COMPAN
Y',child_flex_value_low,parent_flex_value,range_attribute,sysdate)
WHEN flex_value_set_id = 1005024 THEN
INTO
FDW.GL_SEGMENT_VAL_HIERARCHY_new(SEGMENT_ID,SEGMENT_NAME,CHILD_SEGMENT_V
ALUE,PARENT_SEGMENT_VALUE,PARENT_CHILD_FLAG,CREATE_DATE)VALUES(2,'RC',ch
ild_flex_value_low,parent_flex_value,range_attribute,sysdate)
WHEN flex_value_set_id = 1005025 THEN
INTO
FDW.GL_SEGMENT_VAL_HIERARCHY_new(SEGMENT_ID,SEGMENT_NAME,CHILD_SEGMENT_V
ALUE,PARENT_SEGMENT_VALUE,PARENT_CHILD_FLAG,CREATE_DATE)VALUES(3,'ACCOUN
T',child_flex_value_low,parent_flex_value,range_attribute,sysdate)
WHEN flex_value_set_id = 1005026 THEN
INTO
FDW.GL_SEGMENT_VAL_HIERARCHY_new(SEGMENT_ID,SEGMENT_NAME,CHILD_SEGMENT_V
ALUE,PARENT_SEGMENT_VALUE,PARENT_CHILD_FLAG,CREATE_DATE)VALUES(4,'PROD',
child_flex_value_low,parent_flex_value,range_attribute,sysdate)
WHEN flex_value_set_id = 1005027 THEN
INTO
FDW.GL_SEGMENT_VAL_HIERARCHY_new(SEGMENT_ID,SEGMENT_NAME,CHILD_SEGMENT_V
ALUE,PARENT_SEGMENT_VALUE,PARENT_CHILD_FLAG,CREATE_DATE)VALUES(5,'GEO',c
hild_flex_value_low,parent_flex_value,range_attribute,sysdate)
WHEN flex_value_set_id = 1005028 THEN
INTO
FDW.GL_SEGMENT_VAL_HIERARCHY_new(SEGMENT_ID,SEGMENT_NAME,CHILD_SEGMENT_V
ALUE,PARENT_SEGMENT_VALUE,PARENT_CHILD_FLAG,CREATE_DATE)VALUES(6,'ACCOUN
T',child_flex_value_low,parent_flex_value,range_attribute,sysdate)
WHEN flex_value_set_id = 1005029 THEN
INTO
FDW.GL_SEGMENT_VAL_HIERARCHY_new(SEGMENT_ID,SEGMENT_NAME,CHILD_SEGMENT_V
ALUE,PARENT_SEGMENT_VALUE,PARENT_CHILD_FLAG,CREATE_DATE)VALUES(7,'ACCOUN
T',child_flex_value_low,parent_flex_value,range_attribute,sysdate)
select
flex_value_set_id
,flex.child_flex_value_low
,flex.parent_flex_value
,flex.range_attribute
from applsys.fnd_flex_value_norm_hierarchy flex
;


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page