Table -
Sorted Table -
Copybook -
Control File -
Create Table -
Sorted Create Table -
Row Size -
Back To Table Index
---
--- SQL*Loader Control File For OWNER Table
--- Created on: 23-MAY-2020 3:50 PM
--- Created by: +1Copybook (C)
---
OPTIONS(DIRECT=TRUE)
UNRECOVERABLE LOAD DATA
INFILE '.OWNER.txt'
BADFILE 'OWNER.bad'
APPEND
INTO TABLE OWNER
(
OWNER_PROP_KEY POSITION(001:015) INTEGER EXTERNAL NULLIF (OWNER_PROP_KEY=BLANKS),
OWNER_PROP_OWNER_NAME POSITION(016:048) CHAR,
OWNER_PROP_ADDRESS_MAILING1 POSITION(049:081) CHAR,
OWNER_PROP_ADDRESS_MAILING2 POSITION(082:114) CHAR,
OWNER_PROP_ADDRESS_MAILING3 POSITION(115:147) CHAR,
OWNER_PROP_ADDRESS_MAILING4 POSITION(148:180) CHAR,
OWNER_PROP_ADDRESS_PROPERTY POSITION(181:213) CHAR,
OWNER_SUBDIVISION_NAME POSITION(214:263) CHAR,
OWNER_PROP_MILLAGE POSITION(264:267) INTEGER EXTERNAL NULLIF (OWNER_PROP_MILLAGE=BLANKS),
OWNER_PROP_INSPECT_DATE_MONTH POSITION(268:269) INTEGER EXTERNAL NULLIF (OWNER_PROP_INSPECT_DATE_MONTH=BLANKS),
OWNER_PROP_INSPECT_DATE_YEAR POSITION(270:273) INTEGER EXTERNAL NULLIF (OWNER_PROP_INSPECT_DATE_YEAR=BLANKS),
OWNER_PROP_CLUC_CODE POSITION(274:277) CHAR,
OWNER_PROP_SLUC_CODE POSITION(278:281) CHAR,
OWNER_PROP_YEAR_BUILT POSITION(282:285) INTEGER EXTERNAL NULLIF (OWNER_PROP_YEAR_BUILT=BLANKS),
OWNER_PROP_CONDO_UNIT POSITION(286:291) CHAR,
OWNER_PROP_LOT_SIZE POSITION(292:306) CHAR,
OWNER_PROP_CHANGE_DATE POSITION(307:314) INTEGER EXTERNAL NULLIF (OWNER_PROP_CHANGE_DATE=BLANKS),
OWNER_PROP_ASSMT_YEAR POSITION(315:318) INTEGER EXTERNAL NULLIF (OWNER_PROP_ASSMT_YEAR=BLANKS),
OWNER_PROP_LAND_VALUE POSITION(319:329) DECIMAL EXTERNAL NULLIF (OWNER_PROP_LAND_VALUE=blanks),
OWNER_PROP_BLDG_VALUE POSITION(330:340) DECIMAL EXTERNAL NULLIF (OWNER_PROP_BLDG_VALUE=blanks),
OWNER_PROP_TOTAL_VALUE POSITION(341:351) DECIMAL EXTERNAL NULLIF (OWNER_PROP_TOTAL_VALUE=blanks),
OWNER_PROP_HEX_VALUE POSITION(352:358) INTEGER EXTERNAL NULLIF (OWNER_PROP_HEX_VALUE=BLANKS),
OWNER_PROP_WIDOW_AMOUNT POSITION(359:363) INTEGER EXTERNAL NULLIF (OWNER_PROP_WIDOW_AMOUNT=BLANKS),
OWNER_PROP_VETERAN_AMOUNT POSITION(364:368) INTEGER EXTERNAL NULLIF (OWNER_PROP_VETERAN_AMOUNT=BLANKS),
OWNER_PROP_DISABLED_AMOUNT POSITION(369:373) INTEGER EXTERNAL NULLIF (OWNER_PROP_DISABLED_AMOUNT=BLANKS),
OWNER_PROP_TOTAL_EXEMPT POSITION(374:384) DECIMAL EXTERNAL NULLIF (OWNER_PROP_TOTAL_EXEMPT=blanks),
OWNER_PROP_TOTAL_NONEXEMPT POSITION(385:395) DECIMAL EXTERNAL NULLIF (OWNER_PROP_TOTAL_NONEXEMPT=blanks),
OWNER_PROP_SENIOR_AMOUNT POSITION(396:400) INTEGER EXTERNAL NULLIF (OWNER_PROP_SENIOR_AMOUNT=BLANKS),
OWNER_PROP_COUNTY_NONEXEMPT POSITION(401:411) DECIMAL EXTERNAL NULLIF (OWNER_PROP_COUNTY_NONEXEMPT=blanks),
OWNER_PROP_SCHOOL_EXEMPT POSITION(412:422) DECIMAL EXTERNAL NULLIF (OWNER_PROP_SCHOOL_EXEMPT=blanks),
OWNER_PROP_SCHOOL_NONEXEMPT POSITION(423:433) DECIMAL EXTERNAL NULLIF (OWNER_PROP_SCHOOL_NONEXEMPT=blanks),
OWNER_PROP_LAST_ASSMT_YEAR POSITION(434:437) INTEGER EXTERNAL NULLIF (OWNER_PROP_LAST_ASSMT_YEAR=BLANKS),
OWNER_PROP_LAST_LAND_VALUE POSITION(438:448) DECIMAL EXTERNAL NULLIF (OWNER_PROP_LAST_LAND_VALUE=blanks),
OWNER_PROP_LAST_BLDG_VALUE POSITION(449:459) DECIMAL EXTERNAL NULLIF (OWNER_PROP_LAST_BLDG_VALUE=blanks),
OWNER_PROP_LAST_TOTAL_VALUE POSITION(460:470) DECIMAL EXTERNAL NULLIF (OWNER_PROP_LAST_TOTAL_VALUE=blanks),
OWNER_PROP_LAST_HEX_VALUE POSITION(471:477) INTEGER EXTERNAL NULLIF (OWNER_PROP_LAST_HEX_VALUE=BLANKS),
OWNER_PROP_LAST_WIDOW_AMOUNT POSITION(478:482) INTEGER EXTERNAL NULLIF (OWNER_PROP_LAST_WIDOW_AMOUNT=BLANKS),
OWNER_PROP_LAST_VETERAN_AMOUNT POSITION(483:487) INTEGER EXTERNAL NULLIF (OWNER_PROP_LAST_VETERAN_AMOUNT=BLANKS),
OWNER_PROP_LAST_DISABLE_AMOUNT POSITION(488:492) INTEGER EXTERNAL NULLIF (OWNER_PROP_LAST_DISABLE_AMOUNT=BLANKS),
OWNER_PROP_LAST_TOTAL_EXEMPT POSITION(493:503) DECIMAL EXTERNAL NULLIF (OWNER_PROP_LAST_TOTAL_EXEMPT=blanks),
OWNER_PROP_LAST_TOTAL_NONEX POSITION(504:514) DECIMAL EXTERNAL NULLIF (OWNER_PROP_LAST_TOTAL_NONEX=blanks),
OWNER_PROP_LAST_SENIOR_AMOUNT POSITION(515:519) INTEGER EXTERNAL NULLIF (OWNER_PROP_LAST_SENIOR_AMOUNT=BLANKS),
OWNER_PROP_LAST_COUNTY_NONEX POSITION(520:530) DECIMAL EXTERNAL NULLIF (OWNER_PROP_LAST_COUNTY_NONEX=blanks),
OWNER_PROP_LAST_SCHOOL_EXEMPT POSITION(531:541) DECIMAL EXTERNAL NULLIF (OWNER_PROP_LAST_SCHOOL_EXEMPT=blanks),
OWNER_PROP_LAST_SCHOOL_NONEX POSITION(542:552) DECIMAL EXTERNAL NULLIF (OWNER_PROP_LAST_SCHOOL_NONEX=blanks),
OWNER_PROP_PREV_ASSMT_YEAR POSITION(553:556) INTEGER EXTERNAL NULLIF (OWNER_PROP_PREV_ASSMT_YEAR=BLANKS),
OWNER_PROP_PREV_LAND_VALUE POSITION(557:567) DECIMAL EXTERNAL NULLIF (OWNER_PROP_PREV_LAND_VALUE=blanks),
OWNER_PROP_PREV_BLDG_VALUE POSITION(568:578) DECIMAL EXTERNAL NULLIF (OWNER_PROP_PREV_BLDG_VALUE=blanks),
OWNER_PROP_PREV_TOTAL_VALUE POSITION(579:589) DECIMAL EXTERNAL NULLIF (OWNER_PROP_PREV_TOTAL_VALUE=blanks),
OWNER_PROP_PREV_HEX_VALUE POSITION(590:596) INTEGER EXTERNAL NULLIF (OWNER_PROP_PREV_HEX_VALUE=BLANKS),
OWNER_PROP_PREV_WIDOW_AMOUNT POSITION(597:601) INTEGER EXTERNAL NULLIF (OWNER_PROP_PREV_WIDOW_AMOUNT=BLANKS),
OWNER_PROP_PREV_VETERAN_AMOUNT POSITION(602:606) INTEGER EXTERNAL NULLIF (OWNER_PROP_PREV_VETERAN_AMOUNT=BLANKS),
OWNER_PROP_PREV_DISABLE_AMOUNT POSITION(607:611) INTEGER EXTERNAL NULLIF (OWNER_PROP_PREV_DISABLE_AMOUNT=BLANKS),
OWNER_PROP_PREV_TOTAL_EXEMPT POSITION(612:622) DECIMAL EXTERNAL NULLIF (OWNER_PROP_PREV_TOTAL_EXEMPT=blanks),
OWNER_PROP_PREV_TOTAL_NONEX POSITION(623:633) DECIMAL EXTERNAL NULLIF (OWNER_PROP_PREV_TOTAL_NONEX=blanks),
OWNER_PROP_PREV_SENIOR_AMOUNT POSITION(634:638) INTEGER EXTERNAL NULLIF (OWNER_PROP_PREV_SENIOR_AMOUNT=BLANKS),
OWNER_PROP_PREV_COUNTY_NONEX POSITION(639:649) DECIMAL EXTERNAL NULLIF (OWNER_PROP_PREV_COUNTY_NONEX=blanks),
OWNER_PROP_PREV_SCHOOL_EXEMPT POSITION(650:660) DECIMAL EXTERNAL NULLIF (OWNER_PROP_PREV_SCHOOL_EXEMPT=blanks),
OWNER_PROP_PREV_SCHOOL_NONEX POSITION(661:671) DECIMAL EXTERNAL NULLIF (OWNER_PROP_PREV_SCHOOL_NONEX=blanks),
OWNER_PROP_PRI_ZONE POSITION(672:675) CHAR,
OWNER_PROP_BLDG_SQFTG POSITION(676:684) INTEGER EXTERNAL NULLIF (OWNER_PROP_BLDG_SQFTG=BLANKS),
OWNER_PROP_XFEATURES POSITION(685:685) INTEGER EXTERNAL NULLIF (OWNER_PROP_XFEATURES=BLANKS),
OWNER_PROP_BEDROOM POSITION(686:691) INTEGER EXTERNAL NULLIF (OWNER_PROP_BEDROOM=BLANKS),
OWNER_PROP_BATH POSITION(692:696) INTEGER EXTERNAL NULLIF (OWNER_PROP_BATH=BLANKS),
OWNER_WATER_NUMBER POSITION(697:699) INTEGER EXTERNAL NULLIF (OWNER_WATER_NUMBER=BLANKS),
OWNER_ROAD_NUMBER POSITION(700:702) INTEGER EXTERNAL NULLIF (OWNER_ROAD_NUMBER=BLANKS),
OWNER_SEWER_NUMBER POSITION(703:705) INTEGER EXTERNAL NULLIF (OWNER_SEWER_NUMBER=BLANKS),
OWNER_LITE_NUMBER POSITION(706:708) INTEGER EXTERNAL NULLIF (OWNER_LITE_NUMBER=BLANKS),
OWNER_LAST_SALES_DATE_MONTH POSITION(709:710) INTEGER EXTERNAL NULLIF (OWNER_LAST_SALES_DATE_MONTH=BLANKS),
OWNER_LAST_SALES_DATE_YEAR POSITION(711:714) INTEGER EXTERNAL NULLIF (OWNER_LAST_SALES_DATE_YEAR=BLANKS),
OWNER_LAST_SALES_AMOUNT POSITION(715:723) INTEGER EXTERNAL NULLIF (OWNER_LAST_SALES_AMOUNT=BLANKS),
OWNER_LAST_SALES_TYPE POSITION(724:724) INTEGER EXTERNAL NULLIF (OWNER_LAST_SALES_TYPE=BLANKS),
OWNER_PREV_SALES_DATE_MONTH POSITION(725:726) INTEGER EXTERNAL NULLIF (OWNER_PREV_SALES_DATE_MONTH=BLANKS),
OWNER_PREV_SALES_DATE_YEAR POSITION(727:730) INTEGER EXTERNAL NULLIF (OWNER_PREV_SALES_DATE_YEAR=BLANKS),
OWNER_PREV_SALES_AMOUNT POSITION(731:739) INTEGER EXTERNAL NULLIF (OWNER_PREV_SALES_AMOUNT=BLANKS),
OWNER_PREV_SALES_TYPE POSITION(740:740) INTEGER EXTERNAL NULLIF (OWNER_PREV_SALES_TYPE=BLANKS),
OWNER_SALES3_DATE_MONTH POSITION(741:742) INTEGER EXTERNAL NULLIF (OWNER_SALES3_DATE_MONTH=BLANKS),
OWNER_SALES3_DATE_YEAR POSITION(743:746) INTEGER EXTERNAL NULLIF (OWNER_SALES3_DATE_YEAR=BLANKS),
OWNER_SALES3_AMOUNT POSITION(747:755) INTEGER EXTERNAL NULLIF (OWNER_SALES3_AMOUNT=BLANKS),
OWNER_SALES3_TYPE POSITION(756:756) INTEGER EXTERNAL NULLIF (OWNER_SALES3_TYPE=BLANKS),
OWNER_PROP_RESIDENT_YEAR POSITION(757:760) INTEGER EXTERNAL NULLIF (OWNER_PROP_RESIDENT_YEAR=BLANKS),
OWNER_CITY_TAX POSITION(761:775) DECIMAL EXTERNAL ":OWNER_CITY_TAX/100",
OWNER_COUNTY_TAX POSITION(776:790) DECIMAL EXTERNAL ":OWNER_COUNTY_TAX/100",
OWNER_WASTE_TAX POSITION(791:805) DECIMAL EXTERNAL ":OWNER_WASTE_TAX/100",
OWNER_WATER_TAX POSITION(806:820) DECIMAL EXTERNAL ":OWNER_WATER_TAX/100",
OWNER_ROAD_TAX POSITION(821:835) DECIMAL EXTERNAL ":OWNER_ROAD_TAX/100",
OWNER_SEWER_TAX POSITION(836:850) DECIMAL EXTERNAL ":OWNER_SEWER_TAX/100",
OWNER_GROSS_TAX POSITION(851:865) DECIMAL EXTERNAL ":OWNER_GROSS_TAX/100",
OWNER_REFFOLIO_KEY POSITION(866:880) INTEGER EXTERNAL NULLIF (OWNER_REFFOLIO_KEY=BLANKS),
OWNER_LAKE_BELT_DISTRICT POSITION(881:881) CHAR,
OWNER_CTY_SENIOR_EXEMP POSITION(882:886) INTEGER EXTERNAL NULLIF (OWNER_CTY_SENIOR_EXEMP=BLANKS),
OWNER_LAST_CTY_SENIOR_EXEMP POSITION(887:891) INTEGER EXTERNAL NULLIF (OWNER_LAST_CTY_SENIOR_EXEMP=BLANKS),
OWNER_PREV_CTY_SENIOR_EXEMP POSITION(892:896) INTEGER EXTERNAL NULLIF (OWNER_PREV_CTY_SENIOR_EXEMP=BLANKS),
OWNER_BLIND POSITION(897:901) INTEGER EXTERNAL NULLIF (OWNER_BLIND=BLANKS),
OWNER_LAST_BLIND POSITION(902:906) INTEGER EXTERNAL NULLIF (OWNER_LAST_BLIND=BLANKS),
OWNER_PREV_BLIND POSITION(907:911) INTEGER EXTERNAL NULLIF (OWNER_PREV_BLIND=BLANKS),
OWNER_NO_XFEA_LINES POSITION(912:913) INTEGER EXTERNAL NULLIF (OWNER_NO_XFEA_LINES=BLANKS),
OWNER_NO_LEGAL_LINES POSITION(914:915) INTEGER EXTERNAL NULLIF (OWNER_NO_LEGAL_LINES=BLANKS),
OWNER_BLDG_NUMBER_1 POSITION(916:917) INTEGER EXTERNAL NULLIF (OWNER_BLDG_NUMBER_1=BLANKS),
OWNER_XFEA_LINE_NO_1 POSITION(918:919) INTEGER EXTERNAL NULLIF (OWNER_XFEA_LINE_NO_1=BLANKS),
OWNER_XFEA_PRICE_CODE_1 POSITION(920:922) INTEGER EXTERNAL NULLIF (OWNER_XFEA_PRICE_CODE_1=BLANKS),
OWNER_XFEA_UNIT_AREA_1 POSITION(923:931) DECIMAL EXTERNAL ":OWNER_XFEA_UNIT_AREA_1/100",
OWNER_XFEA_ADDED_1 POSITION(932:940) INTEGER EXTERNAL NULLIF (OWNER_XFEA_ADDED_1=BLANKS),
OWNER_XFEA_DESCR_1 POSITION(941:955) CHAR,
OWNER_FILLER1_1_001 POSITION(956:956) CHAR,
OWNER_BLDG_NUMBER_2 POSITION(957:958) INTEGER EXTERNAL NULLIF (OWNER_BLDG_NUMBER_2=BLANKS),
OWNER_XFEA_LINE_NO_2 POSITION(959:960) INTEGER EXTERNAL NULLIF (OWNER_XFEA_LINE_NO_2=BLANKS),
OWNER_XFEA_PRICE_CODE_2 POSITION(961:963) INTEGER EXTERNAL NULLIF (OWNER_XFEA_PRICE_CODE_2=BLANKS),
OWNER_XFEA_UNIT_AREA_2 POSITION(964:972) DECIMAL EXTERNAL ":OWNER_XFEA_UNIT_AREA_2/100",
OWNER_XFEA_ADDED_2 POSITION(973:981) INTEGER EXTERNAL NULLIF (OWNER_XFEA_ADDED_2=BLANKS),
OWNER_XFEA_DESCR_2 POSITION(982:996) CHAR,
OWNER_FILLER1_2_002 POSITION(997:997) CHAR,
OWNER_BLDG_NUMBER_3 POSITION(998:999) INTEGER EXTERNAL NULLIF (OWNER_BLDG_NUMBER_3=BLANKS),
OWNER_XFEA_LINE_NO_3 POSITION(1000:1001) INTEGER EXTERNAL NULLIF (OWNER_XFEA_LINE_NO_3=BLANKS),
OWNER_XFEA_PRICE_CODE_3 POSITION(1002:1004) INTEGER EXTERNAL NULLIF (OWNER_XFEA_PRICE_CODE_3=BLANKS),
OWNER_XFEA_UNIT_AREA_3 POSITION(1005:1013) DECIMAL EXTERNAL ":OWNER_XFEA_UNIT_AREA_3/100",
OWNER_XFEA_ADDED_3 POSITION(1014:1022) INTEGER EXTERNAL NULLIF (OWNER_XFEA_ADDED_3=BLANKS),
OWNER_XFEA_DESCR_3 POSITION(1023:1037) CHAR,
OWNER_FILLER1_3_003 POSITION(1038:1038) CHAR,
OWNER_BLDG_NUMBER_4 POSITION(1039:1040) INTEGER EXTERNAL NULLIF (OWNER_BLDG_NUMBER_4=BLANKS),
OWNER_XFEA_LINE_NO_4 POSITION(1041:1042) INTEGER EXTERNAL NULLIF (OWNER_XFEA_LINE_NO_4=BLANKS),
OWNER_XFEA_PRICE_CODE_4 POSITION(1043:1045) INTEGER EXTERNAL NULLIF (OWNER_XFEA_PRICE_CODE_4=BLANKS),
OWNER_XFEA_UNIT_AREA_4 POSITION(1046:1054) DECIMAL EXTERNAL ":OWNER_XFEA_UNIT_AREA_4/100",
OWNER_XFEA_ADDED_4 POSITION(1055:1063) INTEGER EXTERNAL NULLIF (OWNER_XFEA_ADDED_4=BLANKS),
OWNER_XFEA_DESCR_4 POSITION(1064:1078) CHAR,
OWNER_FILLER1_4_004 POSITION(1079:1079) CHAR,
OWNER_BLDG_NUMBER_5 POSITION(1080:1081) INTEGER EXTERNAL NULLIF (OWNER_BLDG_NUMBER_5=BLANKS),
OWNER_XFEA_LINE_NO_5 POSITION(1082:1083) INTEGER EXTERNAL NULLIF (OWNER_XFEA_LINE_NO_5=BLANKS),
OWNER_XFEA_PRICE_CODE_5 POSITION(1084:1086) INTEGER EXTERNAL NULLIF (OWNER_XFEA_PRICE_CODE_5=BLANKS),
OWNER_XFEA_UNIT_AREA_5 POSITION(1087:1095) DECIMAL EXTERNAL ":OWNER_XFEA_UNIT_AREA_5/100",
OWNER_XFEA_ADDED_5 POSITION(1096:1104) INTEGER EXTERNAL NULLIF (OWNER_XFEA_ADDED_5=BLANKS),
OWNER_XFEA_DESCR_5 POSITION(1105:1119) CHAR,
OWNER_FILLER1_5_005 POSITION(1120:1120) CHAR,
OWNER_LEGAL_DESCR_1 POSITION(1121:1153) CHAR,
OWNER_LEGAL_DESCR_2 POSITION(1154:1186) CHAR,
OWNER_LEGAL_DESCR_3 POSITION(1187:1219) CHAR,
OWNER_LEGAL_DESCR_4 POSITION(1220:1252) CHAR,
OWNER_LEGAL_DESCR_5 POSITION(1253:1285) CHAR,
OWNER_FILLER2_006 POSITION(1286:1286) CHAR
)
To Top - Print - copybook.txt