Well, well, well!
It's Das Ashim K! hehe. How have you been? The code below maybe of
some help to you! hehe.
MERGE INTO EMPLOYEE AS E
USING (SELECT EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT,PHONENO,
HIREDATE, JOB, EDLEVEL,
SEX, BIRTHDATE,SALARY, BONUS, COMM
FROM EMP_TEMP
) AS ET
ON E.EMPNO = ET.EMPNO
WHEN MATCHED THEN
UPDATE SET (SALARY, BONUS, COMM) = (ET.SALARY, ET.BONUS, ET.COMM)
WHEN NOT MATCHED THEN
INSERT (EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT,PHONENO,
HIREDATE, JOB, EDLEVEL, SEX,
BIRTHDATE,SALARY, BONUS, COMM)
VALUES(ET.EMPNO, ET.FIRSTNME, ET.MIDINIT, ET.LASTNAME,
ET.WORKDEPT,ET.PHONENO, ET.HIREDATE,
ET.JOB, ET.EDLEVEL, ET.SEX, ET.BIRTHDATE,ET.SALARY,
ET.BONUS, ET.COMM)
It's Fridayyyyyyyyy! Partyyyyyyyy! Hehe.
Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Dr. Eric J. Smith is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Das Ashim K
[mailto:db2udbdba-ezmlmshield-x90678861.[Email address protected]
Sent: Thursday, March 20, 2008 3:54 PM
To: LazyDBA Discussion
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