 |
 |
Archives of the TeradataForum
Message Posted: Mon, 18 Mar 2013 @ 21:36:26 GMT
| Subj: | | Re: MERGE question |
| |
| From: | | Dieter Noeth |
David Clough wrote:
| | Is the Merge statement really that restrictive ? Does it really demand ALL Columns be set to explicitly set to a value ? | |
No. It's like any INSERT, you might specify the list of columns:
WHEN NOT MATCHED THEN INSERT
( COM_ID
,BUL_ID
,ORD_ID
,ORD_SRKY_ID
,ORD_SRCE_SYSTEM_CD
,ORD_SEQ_NR
)
VALUES (
BO_IN.COM_ID
,BO_IN.BUL_ID
,BO_IN.ORD_ID
,BO_IN.ORD_SRKY_ID
,BO_IN.ORD_SRCE_SYSTEM_CD
,BO_IN.ORD_SEQ_NR
--,BO_IN.ORD_CONT_VL
--,BO_IN.ORD_CONT_WT
);
Dieter
| |
