LOAD DATA
INFILE *
INTO TABLE exception_messages
REPLACE
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(
exception_number
,message
,exme_type
,created_by
,created_on
,exme_comment
,updated_by
,updated_on
)
BEGINDATA
-20000|This indicates an assertion failure - check ERROR_LOGS|E||24-JAN-08|||
-20001|Unable to select quote.  A quote has already been selected or accepted for this enquiry.|E||4-APR-08|||
-20100|Attempt to upload file failed, file may be over 3 megabytes in size or total files for enquiry exceed 10 megabytes|E||6-FEB-08|||
-20110|This enquiry has already been quoted, if you require a new quote please copy this enquiry and request again.|E||10-APR-08|||