Archives of the TeradataForum

Message Posted: Tue, 03 Dec 2003 @ 04:50:49 GMT

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

Should be the APPLY clause of the IMPORT command:

.LAYOUT layout;
.FIELD rectype              1           CHAR(1);
.....
.FIELD DELETE_SW                2777 CHAR(1);
....

.DML LABEL UPSERT_LABEL
DO INSERT FOR MISSING UPDATE ROWS;
SQl statement....

.DML LABEL DELETE_LABEL;
DELETE table
      WHERE
 ACCT_NO = :ACCOUNT_NUMBER;

.IMPORT INFILE filename
        LAYOUT layout
        APPLY UPSERT_LABEL
                      WHERE rectype = '1' AND DELETE_SW NE 'Y'
        APPLY DELETE_LABEL
                      WHERE rectype = '1' AND DELETE_SW ='Y'
 ;

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