--Control File For Copyspace LOAD DATA INFILE out.dat BADFILE out.bad DISCARDFILE out.dis APPEND INTO TABLE BLOCK WHEN TABLE_NAME= 'BLOCK:' FIELDS TERMINATED BY ',' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:6) Char TERMINATED BY WHITESPACE, ID , NAME, URL, DATA, STORAGE_METHOD, DTD ) -- END OF SCRIPT FOR BLOCK TABLE INTO TABLE POSTAL1 WHEN TABLE_NAME= 'POSTAL1:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:8) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, CITY1_E, CODE2_E, COUNTRY1_E, REGION1_E, STREET1_E ) INTO TABLE FOREIGN_REN_EXP_DATE WHEN TABLE_NAME= 'FOREIGN_REN_EXP_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:21) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE SECTION2F_LIMIT_STATEMENT WHEN TABLE_NAME= 'SECTION2F_LIMIT_STATEMENT:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:26) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E ) INTO TABLE MARK_DESCRIPTION WHEN TABLE_NAME= 'MARK_DESCRIPTION:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:17) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E ) INTO TABLE DISCLAIMER WHEN TABLE_NAME= 'DISCLAIMER:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:11) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E ) INTO TABLE PUB_OPPOSITION_DATE WHEN TABLE_NAME= 'PUB_OPPOSITION_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:20) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE SERIAL_NUMBER1 WHEN TABLE_NAME= 'SERIAL_NUMBER1:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:15) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, FILING_DATE1_A, SERIES_CODE_A ) INTO TABLE FOREIGN_REGISTRATION_DATE WHEN TABLE_NAME= 'FOREIGN_REGISTRATION_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:26) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE FIRST_USE_COMMERCE_DATE WHEN TABLE_NAME= 'FIRST_USE_COMMERCE_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:24) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE PSEUDO_MARK WHEN TABLE_NAME= 'PSEUDO_MARK:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E ) INTO TABLE TTAX_DATA_GROUP WHEN TABLE_NAME= 'TTAX_DATA_GROUP:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:16) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, ENTRY_NUMBER_A, TEXT_TYPE_A ) INTO TABLE FOREIGN_FILING_DATE WHEN TABLE_NAME= 'FOREIGN_FILING_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:20) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE RECORD_PRUS WHEN TABLE_NAME= 'RECORD_PRUS:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, AND_OTHERS_E ) INTO TABLE GOODS_SERVICES_TEXT WHEN TABLE_NAME= 'GOODS_SERVICES_TEXT:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:20) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, PRIME_CLASS_A ) INTO TABLE TRANSACTION_DATE1 WHEN TABLE_NAME= 'TRANSACTION_DATE1:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:18) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE RENEWAL_DATE WHEN TABLE_NAME= 'RENEWAL_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:13) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE CLASS_STATUS_DATE WHEN TABLE_NAME= 'CLASS_STATUS_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:18) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE RECORD_GENV WHEN TABLE_NAME= 'RECORD_GENV:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT ) INTO TABLE DEED_EFFECTIVE_DATE WHEN TABLE_NAME= 'DEED_EFFECTIVE_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:20) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE KEY_ACTION WHEN TABLE_NAME= 'KEY_ACTION:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:11) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, CODE_A ) INTO TABLE RECORD_PROP WHEN TABLE_NAME= 'RECORD_PROP:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT ) INTO TABLE PARTY_NAME WHEN TABLE_NAME= 'PARTY_NAME:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:11) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, FIRST_NAME_A, LAST_NAME_A, MIDDLE_NAME_A ) INTO TABLE CONCURRENT_USE_STATEMENT WHEN TABLE_NAME= 'CONCURRENT_USE_STATEMENT:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:25) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, MONTH_A, YEAR_A ) INTO TABLE PUB_DATE WHEN TABLE_NAME= 'PUB_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:9) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE ENTRY_DATE WHEN TABLE_NAME= 'ENTRY_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:11) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE TTAB_STATUS WHEN TABLE_NAME= 'TTAB_STATUS:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, CODE_A ) INTO TABLE BRIEF_CODE WHEN TABLE_NAME= 'BRIEF_CODE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:11) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, CODE_A ) INTO TABLE RECORD_TTAX WHEN TABLE_NAME= 'RECORD_TTAX:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT ) INTO TABLE FOREIGN_EXPIRATION_DATE WHEN TABLE_NAME= 'FOREIGN_EXPIRATION_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:24) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE LINING_STIPPLING_STATEMENT WHEN TABLE_NAME= 'LINING_STIPPLING_STATEMENT:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:27) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E ) INTO TABLE MARK_TRANSLATION WHEN TABLE_NAME= 'MARK_TRANSLATION:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:17) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E ) INTO TABLE PARTY_TYPE WHEN TABLE_NAME= 'PARTY_TYPE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:11) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, OWNER_CODE_A ) INTO TABLE ASGN_NAME WHEN TABLE_NAME= 'ASGN_NAME:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:10) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, FIRST_NAME_A, LAST_NAME_A, MIDDLE_NAME_A ) INTO TABLE PROCEEDING_NUMBER WHEN TABLE_NAME= 'PROCEEDING_NUMBER:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:18) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, PROCEEDING_TYPE_A ) INTO TABLE PRIME_CLASS1 WHEN TABLE_NAME= 'PRIME_CLASS1:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:13) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, CLASS_CODE_A, CLASS_TYPE_A ) INTO TABLE NAME_DESCRIPTION WHEN TABLE_NAME= 'NAME_DESCRIPTION:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:17) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E ) INTO TABLE US_CLASS WHEN TABLE_NAME= 'US_CLASS:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:9) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, CLASS_CODE_A ) INTO TABLE FILING_DATE2 WHEN TABLE_NAME= 'FILING_DATE2:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:13) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE RECORD_OWNX WHEN TABLE_NAME= 'RECORD_OWNX:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, ATTORNEY_NAME_E, DOMESTIC_REPRESENTATIVE_E ) INTO TABLE CANCELLATION_CODE WHEN TABLE_NAME= 'CANCELLATION_CODE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:18) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, CODE_A ) INTO TABLE FOREIGN_COUNTRY_CODE WHEN TABLE_NAME= 'FOREIGN_COUNTRY_CODE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:21) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, CODE_A ) INTO TABLE SIGNED_DATE WHEN TABLE_NAME= 'SIGNED_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE NAME WHEN TABLE_NAME= 'NAME:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:5) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, FIRST_NAME_A, LAST_NAME_A, MIDDLE_NAME_A ) INTO TABLE RECORD_PART WHEN TABLE_NAME= 'RECORD_PART:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, COMPOSED_OF_STATEMENT_E, DBA_AKA_STATEMENT_E, NAME_I, POSTAL1_I ) INTO TABLE MARK_DRAWING_CODE WHEN TABLE_NAME= 'MARK_DRAWING_CODE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:18) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, ILLUSTRATION_SPACE_A, PHYSICAL_APPEARANCE_A, SIZING_CODE_A ) INTO TABLE ENTITY_TYPE WHEN TABLE_NAME= 'ENTITY_TYPE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, CODE_A ) INTO TABLE REGISTRATION_DATE1 WHEN TABLE_NAME= 'REGISTRATION_DATE1:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:19) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE STATUS_CODE1 WHEN TABLE_NAME= 'STATUS_CODE1:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:13) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, CODE_A ) INTO TABLE APNR_DATA_GROUP WHEN TABLE_NAME= 'APNR_DATA_GROUP:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:16) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, ENTRY_NUMBER_A, FILING_DATE1_A, REG_NUM_A, SERIAL_NUMBER_A ) INTO TABLE ASGN_TYPE WHEN TABLE_NAME= 'ASGN_TYPE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:10) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, TYPE_A ) INTO TABLE CORRESPONDENCE_ADDRESS WHEN TABLE_NAME= 'CORRESPONDENCE_ADDRESS:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:23) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, NAME_I, POSTAL1_I ) INTO TABLE RECORD_PARC WHEN TABLE_NAME= 'RECORD_PARC:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, ENTRY_NUMBER_A, CORRESPONDENCE_ADDRESS_I ) INTO TABLE DUE_DATE WHEN TABLE_NAME= 'DUE_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:9) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE APPH_DATA_GROUP WHEN TABLE_NAME= 'APPH_DATA_GROUP:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:16) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, ENTRY_CODE_A, ENTRY_NUMBER_A, ENTRY_TYPE_A, DUE_DATE_I, ENTRY_DATE_I ) INTO TABLE FOREIGN_RENEWAL_DATE WHEN TABLE_NAME= 'FOREIGN_RENEWAL_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:21) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE RECORD_FRGN WHEN TABLE_NAME= 'RECORD_FRGN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, FLAG_FOREI_PRIOR_CLAIM_E, FOREIGN_APP_NUMBER_E, FOREIGN_COUNTRY_CODE_I, FOREIGN_EXPIRATION_DATE_I, FOREIGN_FILING_DATE_I, FOREIGN_REG_NUMBER_E, FOREIGN_REGISTRATION_DATE_I, FOREIGN_REN_EXP_DATE_I, FOREIGN_REN_NUMBER_E, FOREIGN_RENEWAL_DATE_I ) INTO TABLE IN_ANOTHER_FORM_STATEMENT WHEN TABLE_NAME= 'IN_ANOTHER_FORM_STATEMENT:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:26) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, PRIME_CLASS_A ) INTO TABLE RECORDED_DATE WHEN TABLE_NAME= 'RECORDED_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:14) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE RECORD_DEED WHEN TABLE_NAME= 'RECORD_DEED:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, BRIEF_CODE_I, CORRESPONDENCE_ADDRESS_I, FRAME_NUMBER_E, NUMBER_PAGES_E, RECORDED_DATE_I, REEL_NUMBER_E ) INTO TABLE MARK_TYPE_CODE WHEN TABLE_NAME= 'MARK_TYPE_CODE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:15) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, CERTIFICATION_MARK_A, COLLECTIVE_MEM_MARK_A, COLLECTIVE_SERVICE_MARK_A, COLLECTIVE_TRADEMARK_A, SERVICE_MARK_A, TRADEMARK_A ) INTO TABLE UNDEFINED_APPLICATION WHEN TABLE_NAME= 'UNDEFINED_APPLICATION:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:22) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, MONTH_A, YEAR_A ) INTO TABLE ACKNOWLEDGED_DATE WHEN TABLE_NAME= 'ACKNOWLEDGED_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:18) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE RECORD_ASGN WHEN TABLE_NAME= 'RECORD_ASGN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, ACKNOWLEDGED_DATE_I, ASGN_NAME_I, ASGN_TYPE_I, CITIZENSHIP_E, COMPOSED_OF_STATEMENT_E, DBA_AKA_STATEMENT_E, ENTITY_STATEMENT_E, ENTITY_TYPE_I, POSTAL1_I, SIGNED_DATE_I ) INTO TABLE TRADEMARK_PROPS WHEN TABLE_NAME= 'TRADEMARK_PROPS:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:16) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, TYPE_A ) INTO TABLE SUBMISSION_FRONT1 WHEN TABLE_NAME= 'SUBMISSION_FRONT1:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:18) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, KEY_ACTION_I, TRANSACTION_DATE1_I ) INTO TABLE ASSIGNMENT_DATA WHEN TABLE_NAME= 'ASSIGNMENT_DATA:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:16) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, RECORD_DEED_I ) INTO TABLE RECORD_OWNR WHEN TABLE_NAME= 'RECORD_OWNR:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, CITIZENSHIP_E, COMPOSED_OF_STATEMENT_E, CORRESPONDENCE_ADDRESS_I, DBA_AKA_STATEMENT_E, ENTITY_STATEMENT_E, ENTITY_TYPE_I, NAME_CHANGE_TEXT_E, PARTY_NAME_I, PARTY_TYPE_I, POSTAL1_I ) INTO TABLE REMOTE_PROPS1 WHEN TABLE_NAME= 'REMOTE_PROPS1:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:14) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E ) INTO TABLE RECORD_APNR WHEN TABLE_NAME= 'RECORD_APNR:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT ) INTO TABLE LAW_OFFICE WHEN TABLE_NAME= 'LAW_OFFICE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:11) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, CODE_A ) INTO TABLE CANCELLATION_DATE WHEN TABLE_NAME= 'CANCELLATION_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:18) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE STATUS_DATE WHEN TABLE_NAME= 'STATUS_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE RECORD_TTAB WHEN TABLE_NAME= 'RECORD_TTAB:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, FILING_DATE2_I, PROCEEDING_NUMBER_I, STATUS_DATE_I, TTAB_STATUS_I ) INTO TABLE ADV_PROCEEDING_DATA WHEN TABLE_NAME= 'ADV_PROCEEDING_DATA:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:20) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, RECORD_TTAB_I ) INTO TABLE REGISTRATION_AMENDMENT WHEN TABLE_NAME= 'REGISTRATION_AMENDMENT:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:23) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, MONTH_A, YEAR_A ) INTO TABLE PRIOR_GROUP WHEN TABLE_NAME= 'PRIOR_GROUP:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, RECORD_TYPE_A, REL_NUM_A ) INTO TABLE DESIGN_SEARCH_CODE WHEN TABLE_NAME= 'DESIGN_SEARCH_CODE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:19) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E ) INTO TABLE MARK_CERTIFICATION_STATEMENT WHEN TABLE_NAME= 'MARK_CERTIFICATION_STATEMENT:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:29) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E ) INTO TABLE CLASS_STATUS WHEN TABLE_NAME= 'CLASS_STATUS:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:13) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, STATUS_CODE_A ) INTO TABLE RECORD_DSGN WHEN TABLE_NAME= 'RECORD_DSGN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT ) INTO TABLE CERTIFICATE_CORRECTION WHEN TABLE_NAME= 'CERTIFICATE_CORRECTION:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:23) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, MONTH_A, YEAR_A ) INTO TABLE RECORD_DEEX WHEN TABLE_NAME= 'RECORD_DEEX:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, BRIEF_TEXT_E, DEED_EFFECTIVE_DATE_I, JURISDICTION_E ) INTO TABLE PROP_DATA_GROUP WHEN TABLE_NAME= 'PROP_DATA_GROUP:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:16) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, FILING_DATE1_A, REG_NUM_A, SERIAL_NUMBER_A ) INTO TABLE AMEND_REGISTER_DATE WHEN TABLE_NAME= 'AMEND_REGISTER_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:20) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE RECORD_GENX WHEN TABLE_NAME= 'RECORD_GENX:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, ACTUAL_MARK_E, AMEND_REGISTER_DATE_I, ATTORNEY_DOCKET_NUMBER_E, CANCELLATION_CODE_I, CANCELLATION_DATE_I, FILING_DATE2_I, FLAG_AMEND_PRINC_REGIS_E, FLAG_AMEND_SUPP_REGISTER_E, FLAG_CANCEL_PENDING_E, FLAG_CHANGE_REGISTRATION_E, FLAG_CONCURRENT_USE_E, FLAG_CONCURRENT_USE_PROC_E, FLAG_FOREI_PRIOR_CLAIM_E, FLAG_INTENT_TO_USE_E, FLAG_INTENT_TO_USE_CURRENT_E, FLAG_INTERFERENCE_PENDING_E, FLAG_OPPOSITION_PENDING_E, FLAG_PUB_CONCURRENT_E, FLAG_RENEWAL_FILED_E, FLAG_REPUB_SECTION_12C_E, FLAG_SECTION_15_ACK_E, FLAG_SECTION_15_FILED_E, FLAG_SECTION_2F_E, FLAG_SECTION_2F_PART_E, FLAG_SECTION_8_ACCEPT_E, FLAG_SECTION_8_FILED_E, FLAG_SECTI_8_PARTI_ACCEP_E, FLAG_SUPP_REGISTER_E, LAW_OFFICE_I, MARK_DRAWING_CODE_I, MARK_TYPE_CODE_I, PUB_DATE_I, PUB_OPPOSITION_DATE_I, REGISTRATION_DATE1_I, REGISTRATION_NUMBER_E, RENEWAL_DATE_I, SERIAL_NUMBER1_I, STATUS_CODE1_I, STATUS_DATE_I ) INTO TABLE MARK_DATA WHEN TABLE_NAME= 'MARK_DATA:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:10) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, RECORD_GENX_I ) INTO TABLE SUBMISSION_DOCUMENT1 WHEN TABLE_NAME= 'SUBMISSION_DOCUMENT1:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:21) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, ADV_PROCEEDING_DATA_I, ASSIGNMENT_DATA_I, MARK_DATA_I ) INTO TABLE DOC_SUBMISSION1 WHEN TABLE_NAME= 'DOC_SUBMISSION1:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:16) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, SUBMISSION_DOCUMENT1_I, SUBMISSION_FRONT1_I ) INTO TABLE DOC_PROPS1 WHEN TABLE_NAME= 'DOC_PROPS1:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:11) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DOC_SUBMISSION1_I ) INTO TABLE TRADEMARK1 WHEN TABLE_NAME= 'TRADEMARK1:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:11) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, NAME1_A, SERIAL1_A, DOC_PROPS1_I, TRADEMARK_PROPS_I ) INTO TABLE INTERNATIONAL_CLASS WHEN TABLE_NAME= 'INTERNATIONAL_CLASS:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:20) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, CLASS_CODE_A ) INTO TABLE RESTRICT_CLAIM_REGISTRATION WHEN TABLE_NAME= 'RESTRICT_CLAIM_REGISTRATION:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:28) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, MONTH_A, YEAR_A ) INTO TABLE RECORD_APPH WHEN TABLE_NAME= 'RECORD_APPH:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT ) INTO TABLE FIRST_USE_DATE WHEN TABLE_NAME= 'FIRST_USE_DATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:15) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, DATA_E, DAY_A, MONTH_A, YEAR_A ) INTO TABLE RECORD_CLAS WHEN TABLE_NAME= 'RECORD_CLAS:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:12) char TERMINATED BY WHITESPACE, ID, BLOCK, PARENT, CLASS_STATUS_I, CLASS_STATUS_DATE_I, FIRST_USE_COMMERCE_DATE_I, FIRST_USE_DATE_I, PRIME_CLASS1_I ) INTO TABLE ADV_PROCE_DATA_RECOR_APNR_JO WHEN TABLE_NAME= 'ADV_PROCE_DATA_RECOR_APNR_JO:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:29) char TERMINATED BY WHITESPACE, ADV_PROCEEDING_DATA_I, RECORD_APNR_I ) INTO TABLE ADV_PROCE_DATA_RECOR_APPH_JO WHEN TABLE_NAME= 'ADV_PROCE_DATA_RECOR_APPH_JO:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:29) char TERMINATED BY WHITESPACE, ADV_PROCEEDING_DATA_I, RECORD_APPH_I ) INTO TABLE ADV_PROCE_DATA_RECOR_PARC_JO WHEN TABLE_NAME= 'ADV_PROCE_DATA_RECOR_PARC_JO:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:29) char TERMINATED BY WHITESPACE, ADV_PROCEEDING_DATA_I, RECORD_PARC_I ) INTO TABLE ADV_PROCE_DATA_RECOR_PART_JO WHEN TABLE_NAME= 'ADV_PROCE_DATA_RECOR_PART_JO:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:29) char TERMINATED BY WHITESPACE, ADV_PROCEEDING_DATA_I, RECORD_PART_I ) INTO TABLE ADV_PROCE_DATA_RECOR_TTAX_JO WHEN TABLE_NAME= 'ADV_PROCE_DATA_RECOR_TTAX_JO:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:29) char TERMINATED BY WHITESPACE, ADV_PROCEEDING_DATA_I, RECORD_TTAX_I ) INTO TABLE ASSIG_DATA_RECOR_ASGN_JOIN WHEN TABLE_NAME= 'ASSIG_DATA_RECOR_ASGN_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:27) char TERMINATED BY WHITESPACE, ASSIGNMENT_DATA_I, RECORD_ASGN_I ) INTO TABLE ASSIG_DATA_RECOR_DEEX_JOIN WHEN TABLE_NAME= 'ASSIG_DATA_RECOR_DEEX_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:27) char TERMINATED BY WHITESPACE, ASSIGNMENT_DATA_I, RECORD_DEEX_I ) INTO TABLE ASSIG_DATA_RECOR_PROP_JOIN WHEN TABLE_NAME= 'ASSIG_DATA_RECOR_PROP_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:27) char TERMINATED BY WHITESPACE, ASSIGNMENT_DATA_I, RECORD_PROP_I ) INTO TABLE MARK_DATA_RECORD_CLAS_JOIN WHEN TABLE_NAME= 'MARK_DATA_RECORD_CLAS_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:27) char TERMINATED BY WHITESPACE, MARK_DATA_I, RECORD_CLAS_I ) INTO TABLE MARK_DATA_RECORD_DSGN_JOIN WHEN TABLE_NAME= 'MARK_DATA_RECORD_DSGN_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:27) char TERMINATED BY WHITESPACE, MARK_DATA_I, RECORD_DSGN_I ) INTO TABLE MARK_DATA_RECORD_FRGN_JOIN WHEN TABLE_NAME= 'MARK_DATA_RECORD_FRGN_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:27) char TERMINATED BY WHITESPACE, MARK_DATA_I, RECORD_FRGN_I ) INTO TABLE MARK_DATA_RECORD_GENV_JOIN WHEN TABLE_NAME= 'MARK_DATA_RECORD_GENV_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:27) char TERMINATED BY WHITESPACE, MARK_DATA_I, RECORD_GENV_I ) INTO TABLE MARK_DATA_RECORD_OWNR_JOIN WHEN TABLE_NAME= 'MARK_DATA_RECORD_OWNR_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:27) char TERMINATED BY WHITESPACE, MARK_DATA_I, RECORD_OWNR_I ) INTO TABLE MARK_DATA_RECORD_OWNX_JOIN WHEN TABLE_NAME= 'MARK_DATA_RECORD_OWNX_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:27) char TERMINATED BY WHITESPACE, MARK_DATA_I, RECORD_OWNX_I ) INTO TABLE MARK_DATA_RECORD_PRUS_JOIN WHEN TABLE_NAME= 'MARK_DATA_RECORD_PRUS_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:27) char TERMINATED BY WHITESPACE, MARK_DATA_I, RECORD_PRUS_I ) INTO TABLE RECOR_APNR_APNR_DATA_GROUP_J WHEN TABLE_NAME= 'RECOR_APNR_APNR_DATA_GROUP_J:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:29) char TERMINATED BY WHITESPACE, RECORD_APNR_I, APNR_DATA_GROUP_I ) INTO TABLE RECOR_APPH_APPH_DATA_GROUP_J WHEN TABLE_NAME= 'RECOR_APPH_APPH_DATA_GROUP_J:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:29) char TERMINATED BY WHITESPACE, RECORD_APPH_I, APPH_DATA_GROUP_I ) INTO TABLE RECOR_CLAS_INTER_CLASS_JOIN WHEN TABLE_NAME= 'RECOR_CLAS_INTER_CLASS_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:28) char TERMINATED BY WHITESPACE, RECORD_CLAS_I, INTERNATIONAL_CLASS_I ) INTO TABLE RECORD_CLAS_US_CLASS_JOIN WHEN TABLE_NAME= 'RECORD_CLAS_US_CLASS_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:26) char TERMINATED BY WHITESPACE, RECORD_CLAS_I, US_CLASS_I ) INTO TABLE RECOR_DSGN_DESIG_SEARC_CODE WHEN TABLE_NAME= 'RECOR_DSGN_DESIG_SEARC_CODE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:28) char TERMINATED BY WHITESPACE, RECORD_DSGN_I, DESIGN_SEARCH_CODE_I ) INTO TABLE RECOR_GENV_CERTI_CORRE_JOIN WHEN TABLE_NAME= 'RECOR_GENV_CERTI_CORRE_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:28) char TERMINATED BY WHITESPACE, RECORD_GENV_I, CERTIFICATE_CORRECTION_I ) INTO TABLE RECOR_GENV_CONCU_USE_STATE_J WHEN TABLE_NAME= 'RECOR_GENV_CONCU_USE_STATE_J:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:29) char TERMINATED BY WHITESPACE, RECORD_GENV_I, CONCURRENT_USE_STATEMENT_I ) INTO TABLE RECORD_GENV_DISCLAIMER_JOIN WHEN TABLE_NAME= 'RECORD_GENV_DISCLAIMER_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:28) char TERMINATED BY WHITESPACE, RECORD_GENV_I, DISCLAIMER_I ) INTO TABLE RECOR_GENV_GOODS_SERVI_TEXT WHEN TABLE_NAME= 'RECOR_GENV_GOODS_SERVI_TEXT:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:28) char TERMINATED BY WHITESPACE, RECORD_GENV_I, GOODS_SERVICES_TEXT_I ) INTO TABLE RECOR_GENV_IN_ANOTH_FORM_STA WHEN TABLE_NAME= 'RECOR_GENV_IN_ANOTH_FORM_STA:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:29) char TERMINATED BY WHITESPACE, RECORD_GENV_I, IN_ANOTHER_FORM_STATEMENT_I ) INTO TABLE RECOR_GENV_LININ_STIPP_STATE WHEN TABLE_NAME= 'RECOR_GENV_LININ_STIPP_STATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:29) char TERMINATED BY WHITESPACE, RECORD_GENV_I, LINING_STIPPLING_STATEMENT_I ) INTO TABLE RECOR_GENV_MARK_CERTI_STATE WHEN TABLE_NAME= 'RECOR_GENV_MARK_CERTI_STATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:28) char TERMINATED BY WHITESPACE, RECORD_GENV_I, MARK_CERTIFICATION_STATEMENT_I ) INTO TABLE RECOR_GENV_MARK_DESCR_JOIN WHEN TABLE_NAME= 'RECOR_GENV_MARK_DESCR_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:27) char TERMINATED BY WHITESPACE, RECORD_GENV_I, MARK_DESCRIPTION_I ) INTO TABLE RECOR_GENV_MARK_TRANS_JOIN WHEN TABLE_NAME= 'RECOR_GENV_MARK_TRANS_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:27) char TERMINATED BY WHITESPACE, RECORD_GENV_I, MARK_TRANSLATION_I ) INTO TABLE RECOR_GENV_NAME_DESCR_JOIN WHEN TABLE_NAME= 'RECOR_GENV_NAME_DESCR_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:27) char TERMINATED BY WHITESPACE, RECORD_GENV_I, NAME_DESCRIPTION_I ) INTO TABLE RECORD_GENV_PSEUDO_MARK_JOIN WHEN TABLE_NAME= 'RECORD_GENV_PSEUDO_MARK_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:29) char TERMINATED BY WHITESPACE, RECORD_GENV_I, PSEUDO_MARK_I ) INTO TABLE RECOR_GENV_REGIS_AMEND_JOIN WHEN TABLE_NAME= 'RECOR_GENV_REGIS_AMEND_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:28) char TERMINATED BY WHITESPACE, RECORD_GENV_I, REGISTRATION_AMENDMENT_I ) INTO TABLE RECOR_GENV_RESTR_CLAIM_REGIS WHEN TABLE_NAME= 'RECOR_GENV_RESTR_CLAIM_REGIS:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:29) char TERMINATED BY WHITESPACE, RECORD_GENV_I, RESTRICT_CLAIM_REGISTRATION_I ) INTO TABLE RECOR_GENV_SECTI_LIMIT_STATE WHEN TABLE_NAME= 'RECOR_GENV_SECTI_LIMIT_STATE:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:29) char TERMINATED BY WHITESPACE, RECORD_GENV_I, SECTION2F_LIMIT_STATEMENT_I ) INTO TABLE RECOR_GENV_UNDEF_APPLI_JOIN WHEN TABLE_NAME= 'RECOR_GENV_UNDEF_APPLI_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:28) char TERMINATED BY WHITESPACE, RECORD_GENV_I, UNDEFINED_APPLICATION_I ) INTO TABLE RECOR_PROP_PROP_DATA_GROUP_J WHEN TABLE_NAME= 'RECOR_PROP_PROP_DATA_GROUP_J:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:29) char TERMINATED BY WHITESPACE, RECORD_PROP_I, PROP_DATA_GROUP_I ) INTO TABLE RECORD_PRUS_PRIOR_GROUP_JOIN WHEN TABLE_NAME= 'RECORD_PRUS_PRIOR_GROUP_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:29) char TERMINATED BY WHITESPACE, RECORD_PRUS_I, PRIOR_GROUP_I ) INTO TABLE RECOR_TTAX_TTAX_DATA_GROUP_J WHEN TABLE_NAME= 'RECOR_TTAX_TTAX_DATA_GROUP_J:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:29) char TERMINATED BY WHITESPACE, RECORD_TTAX_I, TTAX_DATA_GROUP_I ) INTO TABLE TRADE_REMOT_PROPS_JOIN WHEN TABLE_NAME= 'TRADE_REMOT_PROPS_JOIN:' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( TABLE_NAME FILLER POSITION(1:23) char TERMINATED BY WHITESPACE, TRADEMARK1_I, REMOTE_PROPS1_I )