.logtable EDW_DBA_DB.log_CONTENTOWNER;                           
.logon ampd/sysdba,*****;                                               
.BEGIN IMPORT MLOAD TABLES EDW_DBA_DB.CONTENTOWNER;              
                                                
.LAYOUT INSLAYOUT;                             
                                               
                                               
.FIELD      ContentOwnerId                       *    VARCHAR(25);
.FIELD      ContentOwner                         *    VARCHAR(255);
.FIELD      EffectiveFromDate                    *    VARCHAR(19);
.FIELD      EffectiveToDate                      *    VARCHAR(19);
.FIELD      ContentOwnerId                       *    VARCHAR(25);
.FIELD      ContentOwner                         *    VARCHAR(255);
.FIELD      EffectiveFromDate                    *    VARCHAR(19);
.FIELD      EffectiveToDate                      *    VARCHAR(19);
                                               
.DML LABEL UpdInsDML                           
DO INSERT FOR MISSING UPDATE ROWS;             
                                               
                                               
UPDATE EDW_DBA_DB.CONTENTOWNER     
SET             
ContentOwner = :ContentOwner,
EffectiveToDate = :EffectiveToDate
ContentOwnerId = :ContentOwnerId AND
EffectiveFromDate = :EffectiveFromDate;
INSERT EDW_DBA_DB.CONTENTOWNER(ContentOwnerId,
ContentOwner,
EffectiveFromDate,
EffectiveToDate) VALUES
(:ContentOwnerId,
:ContentOwner,
:EffectiveFromDate,
:EffectiveToDate);
                                               
.IMPORT INFILE  T.TXT                             
                                               
 FORMAT VARTEXT       '|'                   
                                               
 LAYOUT INSLAYOUT                              
                                               
 APPLY UpdInsDML;                              
                                               
.END MLOAD;                                    
                                               
.LOGOFF;