LOAD DATA
INFILE *
INTO TABLE parties
REPLACE
FIELDS TERMINATED BY '|'
(
manu_ref
,created_by
,shortcode
,name
,description
,created_on
,updated_on
,updated_by
,mktp_ref
,lt_7b_contract_ref
,gt_7b_contract_ref
,adversarial_contract_ref
,username
,status
,first_name
,last_name
,personal_title
,comments
,id
,prty_type
)
BEGINDATA
|advantica||||08-NOV-07|||||||advantica|OPEN|Advantica|User|Mr|User|1|PERS