LOAD DATA
     INFILE 'sample.txt'
     INSERT
     INTO TABLE TEST_RECORDS
     WHEN REC_TYPE_HDR='HDR'
     FIELDS TERMINATED BY '|' 
     TRAILING NULLCOLS
     ( 
       REC_TYPE_HDR   CHAR "LTRIM(RTRIM(:REC_TYPE_HDR))"
      ,HDR_DOC_TYPE     
      ,HDR_CMPY_NAME      
      ,HDR_DOC_DATE  date "MM/DD/YYYY HH24:MI:SS" 
      ,HDR_TRANS_ID 
     )
     INTO TABLE TEST_RECORDS
     WHEN REC_TYPE_DTL='DTL'
     FIELDS TERMINATED BY '|' 
     TRAILING NULLCOLS
    (
       REC_TYPE_DTL   POSITION(1:3) CHAR "LTRIM(RTRIM(:REC_TYPE_DTL))"
      ,TRAN_TYPE  CHAR "TRIM(:TRAN_TYPE)"  
	  ,LINE_COMP  CHAR "TRIM(:LINE_COMPANY)" 
    )

 REC_TYPE_HDR HDR_DOC_TYPE HDR_CMPY_NAME        HDR_DOC_DATE               HDR_TRANS_ID       REC_TYPE_DTL     TRAN_TYPE LINE_COMP
 HDR          RCPTCONFRM    XXXXXXX XXXXXXX    1/29/0013 10:29:25 AM       70346508
                                                                                                     DTL                    603