Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 18 Mar 2013 @ 21:36:26 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020