LOAD DATA
INFILE 'E:\84db\ot_patent2008-06-29 12-27-20.txt'
BADFILE 'E:\84db\ot_patent2008-06-29 12-27-20.bad'
DISCARDFILE 'E:\84db\ot_patent2008-06-29 12-27-20.dsc'

INTO TABLE "HPS"."OT_PATENT"
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(ID,
NAME char(4000),
APPLY_NUMBER char(4000),
APPLY_DATE char(4000),
PUBLISH_NUMBER char(4000),
PUBLISH_DATE char(4000),
PROPOSER char(4000),
ADDRESS char(4000),
MAIN_CLASS char(4000),
ANTIBODY_CLASS char(4000),
ORIGINATOR char(4000),
DEPUTY char(4000),
DEPUTY_INSTITUTION char(4000),
URL char(4000),
COUNTRY char(4000),
LAWSTATE0 char(4000),
LAWSTATE1 char(4000),
LAWSTATE2 char(4000),
LAWSTATE3 char(4000),
LAWSTATE4 char(4000),
LAWSTATE5 char(4000),
CURRENTSTATE char(4000),
PCT_APPLY_NUMBER char(4000),
PCT_APPLY_DATE char(4000),
PCT_OPEN_NUMBER char(4000),
PCT_OPEN_DATE char(4000),
PCT_IN_COUNTRY_DATE char(4000),
MAIN_POWER char(4000),
PROVINCE char(4000),
EUROPE_CLASS char(4000),
PATENT_FAMILY char(4000),
UPDATE_TIME char(4000),
DOCTYPE char(4000),
PRIORITY)