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
;

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