LOAD DATA
INFILE *
INTO TABLE party_roles
REPLACE
FIELDS TERMINATED BY '|'
(
prty_id
,rt_code
,id
,start_date
,end_date
,description
)
BEGINDATA
200|SUPP|2001|08-NOV-07|||
201|SUPP|2011|08-NOV-07|||
202|SUPP|2021|08-NOV-07|||
203|SUPP|2031|08-NOV-07|||
204|SUPP|2041|08-NOV-07|||
205|SUPP|2051|08-NOV-07|||
206|SUPP|2061|08-NOV-07|||
207|SUPP|2071|08-NOV-07|||
208|SUPP|2081|08-NOV-07|||
400|MIPADMIN|4001|08-NOV-07|||
401|MIPADMIN|4011|08-NOV-07|||
402|MIPADMIN|4021|08-NOV-07|||
403|MIPADMIN|4031|08-NOV-07|||
404|AGENT|4041|08-NOV-07|||
405|AGENT|4051|08-NOV-07|||
406|AGENT|4061|08-NOV-07|||
407|AGENT|4071|08-NOV-07|||
408|AGENT|4081|08-NOV-07|||
409|CS|4082|04-FEB-08|||
410|CS|4083|04-FEB-08|||
411|CS|4084|04-FEB-08|||
412|ICU|4085|04-FEB-08|||
413|ICU|4086|04-FEB-08|||
414|ICU|4087|04-FEB-08|||
1|MIPADMIN|4091|08-NOV-07|||
419|SUPPADMIN|5000|03-FEB-08|||
420|SUPPADMIN|5001|03-FEB-08|||
421|SUPPADMIN|5002|03-FEB-08|||