--- --- DB2 Load File For OWNER Table --- Created on: 23-MAY-2020 10:46 AM --- Created by: +1Copybook (C) --- DB2 LOAD FROM OWNER.dat OF ASC RECLEN=2767 METHOD L ( 001 015, 016 048, 049 081, 082 114, 115 147, 148 180, 181 213, 214 263, 264 267, 268 269, 270 273, 274 277, 278 281, 282 285, 286 291, 292 306, 307 314, 315 318, 319 329, 330 340, 341 351, 352 358, 359 363, 364 368, 369 373, 374 384, 385 395, 396 400, 401 411, 412 422, 423 433, 434 437, 438 448, 449 459, 460 470, 471 477, 478 482, 483 487, 488 492, 493 503, 504 514, 515 519, 520 530, 531 541, 542 552, 553 556, 557 567, 568 578, 579 589, 590 596, 597 601, 602 606, 607 611, 612 622, 623 633, 634 638, 639 649, 650 660, 661 671, 672 675, 676 684, 685 685, 686 691, 692 696, 697 699, 700 702, 703 705, 706 708, 709 710, 711 714, 715 723, 724 724, 725 726, 727 730, 731 739, 740 740, 741 742, 743 746, 747 755, 756 756, 757 760, 761 775, 776 790, 791 805, 806 820, 821 835, 836 850, 851 865, 866 880, 881 881, 882 886, 887 891, 892 896, 897 901, 902 906, 907 911, 912 913, 914 915, 916 917, 918 919, 920 922, 923 931, 932 940, 941 955, 957 958, 959 960, 961 963, 964 972, 973 981, 982 996, 998 999, 1000 1001, 1002 1004, 1005 1013, 1014 1022, 1023 1037, 1039 1040, 1041 1042, 1043 1045, 1046 1054, 1055 1063, 1064 1078, 1080 1081, 1082 1083, 1084 1086, 1087 1095, 1096 1104, 1105 1119, 1121 1122, 1123 1124, 1125 1127, 1128 1136, 1137 1145, 1146 1160, 1162 1163, 1164 1165, 1166 1168, 1169 1177, 1178 1186, 1187 1201, 1203 1204, 1205 1206, 1207 1209, 1210 1218, 1219 1227, 1228 1242, 1244 1245, 1246 1247, 1248 1250, 1251 1259, 1260 1268, 1269 1283, 1285 1286, 1287 1288, 1289 1291, 1292 1300, 1301 1309, 1310 1324, 1326 1327, 1328 1329, 1330 1332, 1333 1341, 1342 1350, 1351 1365, 1367 1368, 1369 1370, 1371 1373, 1374 1382, 1383 1391, 1392 1406, 1408 1409, 1410 1411, 1412 1414, 1415 1423, 1424 1432, 1433 1447, 1449 1450, 1451 1452, 1453 1455, 1456 1464, 1465 1473, 1474 1488, 1490 1491, 1492 1493, 1494 1496, 1497 1505, 1506 1514, 1515 1529, 1531 1532, 1533 1534, 1535 1537, 1538 1546, 1547 1555, 1556 1570, 1572 1573, 1574 1575, 1576 1578, 1579 1587, 1588 1596, 1597 1611, 1613 1614, 1615 1616, 1617 1619, 1620 1628, 1629 1637, 1638 1652, 1654 1655, 1656 1657, 1658 1660, 1661 1669, 1670 1678, 1679 1693, 1695 1696, 1697 1698, 1699 1701, 1702 1710, 1711 1719, 1720 1734, 1736 1737, 1738 1739, 1740 1742, 1743 1751, 1752 1760, 1761 1775, 1777 1778, 1779 1780, 1781 1783, 1784 1792, 1793 1801, 1802 1816, 1818 1819, 1820 1821, 1822 1824, 1825 1833, 1834 1842, 1843 1857, 1859 1860, 1861 1862, 1863 1865, 1866 1874, 1875 1883, 1884 1898, 1900 1901, 1902 1903, 1904 1906, 1907 1915, 1916 1924, 1925 1939, 1941 1973, 1974 2006, 2007 2039, 2040 2072, 2073 2105, 2106 2138, 2139 2171, 2172 2204, 2205 2237, 2238 2270, 2271 2303, 2304 2336, 2337 2369, 2370 2402, 2403 2435, 2436 2468, 2469 2501, 2502 2534, 2535 2567, 2568 2600, 2601 2633, 2634 2666, 2667 2699, 2700 2732, 2733 2765 ) INSERT INTO OWNER ( OWNER_PROP_KEY, OWNER_PROP_OWNER_NAME, OWNER_PROP_ADDRESS_MAILING1, OWNER_PROP_ADDRESS_MAILING2, OWNER_PROP_ADDRESS_MAILING3, OWNER_PROP_ADDRESS_MAILING4, OWNER_PROP_ADDRESS_PROPERTY, OWNER_SUBDIVISION_NAME, OWNER_PROP_MILLAGE, OWNER_PROP_INSPECT_DATE_MONTH, OWNER_PROP_INSPECT_DATE_YEAR, OWNER_PROP_CLUC_CODE, OWNER_PROP_SLUC_CODE, OWNER_PROP_YEAR_BUILT, OWNER_PROP_CONDO_UNIT, OWNER_PROP_LOT_SIZE, OWNER_PROP_CHANGE_DATE, OWNER_PROP_ASSMT_YEAR, OWNER_PROP_LAND_VALUE, OWNER_PROP_BLDG_VALUE, OWNER_PROP_TOTAL_VALUE, OWNER_PROP_HEX_VALUE, OWNER_PROP_WIDOW_AMOUNT, OWNER_PROP_VETERAN_AMOUNT, OWNER_PROP_DISABLED_AMOUNT, OWNER_PROP_TOTAL_EXEMPT, OWNER_PROP_TOTAL_NONEXEMPT, OWNER_PROP_SENIOR_AMOUNT, OWNER_PROP_COUNTY_NONEXEMPT, OWNER_PROP_SCHOOL_EXEMPT, OWNER_PROP_SCHOOL_NONEXEMPT, OWNER_PROP_LAST_ASSMT_YEAR, OWNER_PROP_LAST_LAND_VALUE, OWNER_PROP_LAST_BLDG_VALUE, OWNER_PROP_LAST_TOTAL_VALUE, OWNER_PROP_LAST_HEX_VALUE, OWNER_PROP_LAST_WIDOW_AMOUNT, OWNER_PROP_LAST_VETERAN_AMOUNT, OWNER_PROP_LAST_DISABLE_AMOUNT, OWNER_PROP_LAST_TOTAL_EXEMPT, OWNER_PROP_LAST_TOTAL_NONEX, OWNER_PROP_LAST_SENIOR_AMOUNT, OWNER_PROP_LAST_COUNTY_NONEX, OWNER_PROP_LAST_SCHOOL_EXEMPT, OWNER_PROP_LAST_SCHOOL_NONEX, OWNER_PROP_PREV_ASSMT_YEAR, OWNER_PROP_PREV_LAND_VALUE, OWNER_PROP_PREV_BLDG_VALUE, OWNER_PROP_PREV_TOTAL_VALUE, OWNER_PROP_PREV_HEX_VALUE, OWNER_PROP_PREV_WIDOW_AMOUNT, OWNER_PROP_PREV_VETERAN_AMOUNT, OWNER_PROP_PREV_DISABLE_AMOUNT, OWNER_PROP_PREV_TOTAL_EXEMPT, OWNER_PROP_PREV_TOTAL_NONEX, OWNER_PROP_PREV_SENIOR_AMOUNT, OWNER_PROP_PREV_COUNTY_NONEX, OWNER_PROP_PREV_SCHOOL_EXEMPT, OWNER_PROP_PREV_SCHOOL_NONEX, OWNER_PROP_PRI_ZONE, OWNER_PROP_BLDG_SQFTG, OWNER_PROP_XFEATURES, OWNER_PROP_BEDROOM, OWNER_PROP_BATH, OWNER_WATER_NUMBER, OWNER_ROAD_NUMBER, OWNER_SEWER_NUMBER, OWNER_LITE_NUMBER, OWNER_LAST_SALES_DATE_MONTH, OWNER_LAST_SALES_DATE_YEAR, OWNER_LAST_SALES_AMOUNT, OWNER_LAST_SALES_TYPE, OWNER_PREV_SALES_DATE_MONTH, OWNER_PREV_SALES_DATE_YEAR, OWNER_PREV_SALES_AMOUNT, OWNER_PREV_SALES_TYPE, OWNER_SALES3_DATE_MONTH, OWNER_SALES3_DATE_YEAR, OWNER_SALES3_AMOUNT, OWNER_SALES3_TYPE, OWNER_PROP_RESIDENT_YEAR, OWNER_CITY_TAX, OWNER_COUNTY_TAX, OWNER_WASTE_TAX, OWNER_WATER_TAX, OWNER_ROAD_TAX, OWNER_SEWER_TAX, OWNER_GROSS_TAX, OWNER_REFFOLIO_KEY, OWNER_LAKE_BELT_DISTRICT, OWNER_CTY_SENIOR_EXEMP, OWNER_LAST_CTY_SENIOR_EXEMP, OWNER_PREV_CTY_SENIOR_EXEMP, OWNER_BLIND, OWNER_LAST_BLIND, OWNER_PREV_BLIND, OWNER_NO_XFEA_LINES, OWNER_NO_LEGAL_LINES, OWNER_BLDG_NUMBER_1_1, OWNER_XFEA_LINE_NO_1_1, OWNER_XFEA_PRICE_CODE_1_1, OWNER_XFEA_UNIT_AREA_1_1, OWNER_XFEA_ADDED_1_1, OWNER_XFEA_DESCR_1_1, OWNER_BLDG_NUMBER_2_1, OWNER_XFEA_LINE_NO_2_1, OWNER_XFEA_PRICE_CODE_2_1, OWNER_XFEA_UNIT_AREA_2_1, OWNER_XFEA_ADDED_2_1, OWNER_XFEA_DESCR_2_1, OWNER_BLDG_NUMBER_3_1, OWNER_XFEA_LINE_NO_3_1, OWNER_XFEA_PRICE_CODE_3_1, OWNER_XFEA_UNIT_AREA_3_1, OWNER_XFEA_ADDED_3_1, OWNER_XFEA_DESCR_3_1, OWNER_BLDG_NUMBER_4_1, OWNER_XFEA_LINE_NO_4_1, OWNER_XFEA_PRICE_CODE_4_1, OWNER_XFEA_UNIT_AREA_4_1, OWNER_XFEA_ADDED_4_1, OWNER_XFEA_DESCR_4_1, OWNER_BLDG_NUMBER_5_1, OWNER_XFEA_LINE_NO_5_1, OWNER_XFEA_PRICE_CODE_5_1, OWNER_XFEA_UNIT_AREA_5_1, OWNER_XFEA_ADDED_5_1, OWNER_XFEA_DESCR_5_1, OWNER_BLDG_NUMBER_1_2, OWNER_XFEA_LINE_NO_1_2, OWNER_XFEA_PRICE_CODE_1_2, OWNER_XFEA_UNIT_AREA_1_2, OWNER_XFEA_ADDED_1_2, OWNER_XFEA_DESCR_1_2, OWNER_BLDG_NUMBER_2_2, OWNER_XFEA_LINE_NO_2_2, OWNER_XFEA_PRICE_CODE_2_2, OWNER_XFEA_UNIT_AREA_2_2, OWNER_XFEA_ADDED_2_2, OWNER_XFEA_DESCR_2_2, OWNER_BLDG_NUMBER_3_2, OWNER_XFEA_LINE_NO_3_2, OWNER_XFEA_PRICE_CODE_3_2, OWNER_XFEA_UNIT_AREA_3_2, OWNER_XFEA_ADDED_3_2, OWNER_XFEA_DESCR_3_2, OWNER_BLDG_NUMBER_4_2, OWNER_XFEA_LINE_NO_4_2, OWNER_XFEA_PRICE_CODE_4_2, OWNER_XFEA_UNIT_AREA_4_2, OWNER_XFEA_ADDED_4_2, OWNER_XFEA_DESCR_4_2, OWNER_BLDG_NUMBER_5_2, OWNER_XFEA_LINE_NO_5_2, OWNER_XFEA_PRICE_CODE_5_2, OWNER_XFEA_UNIT_AREA_5_2, OWNER_XFEA_ADDED_5_2, OWNER_XFEA_DESCR_5_2, OWNER_BLDG_NUMBER_1_3, OWNER_XFEA_LINE_NO_1_3, OWNER_XFEA_PRICE_CODE_1_3, OWNER_XFEA_UNIT_AREA_1_3, OWNER_XFEA_ADDED_1_3, OWNER_XFEA_DESCR_1_3, OWNER_BLDG_NUMBER_2_3, OWNER_XFEA_LINE_NO_2_3, OWNER_XFEA_PRICE_CODE_2_3, OWNER_XFEA_UNIT_AREA_2_3, OWNER_XFEA_ADDED_2_3, OWNER_XFEA_DESCR_2_3, OWNER_BLDG_NUMBER_3_3, OWNER_XFEA_LINE_NO_3_3, OWNER_XFEA_PRICE_CODE_3_3, OWNER_XFEA_UNIT_AREA_3_3, OWNER_XFEA_ADDED_3_3, OWNER_XFEA_DESCR_3_3, OWNER_BLDG_NUMBER_4_3, OWNER_XFEA_LINE_NO_4_3, OWNER_XFEA_PRICE_CODE_4_3, OWNER_XFEA_UNIT_AREA_4_3, OWNER_XFEA_ADDED_4_3, OWNER_XFEA_DESCR_4_3, OWNER_BLDG_NUMBER_5_3, OWNER_XFEA_LINE_NO_5_3, OWNER_XFEA_PRICE_CODE_5_3, OWNER_XFEA_UNIT_AREA_5_3, OWNER_XFEA_ADDED_5_3, OWNER_XFEA_DESCR_5_3, OWNER_BLDG_NUMBER_1_4, OWNER_XFEA_LINE_NO_1_4, OWNER_XFEA_PRICE_CODE_1_4, OWNER_XFEA_UNIT_AREA_1_4, OWNER_XFEA_ADDED_1_4, OWNER_XFEA_DESCR_1_4, OWNER_BLDG_NUMBER_2_4, OWNER_XFEA_LINE_NO_2_4, OWNER_XFEA_PRICE_CODE_2_4, OWNER_XFEA_UNIT_AREA_2_4, OWNER_XFEA_ADDED_2_4, OWNER_XFEA_DESCR_2_4, OWNER_BLDG_NUMBER_3_4, OWNER_XFEA_LINE_NO_3_4, OWNER_XFEA_PRICE_CODE_3_4, OWNER_XFEA_UNIT_AREA_3_4, OWNER_XFEA_ADDED_3_4, OWNER_XFEA_DESCR_3_4, OWNER_BLDG_NUMBER_4_4, OWNER_XFEA_LINE_NO_4_4, OWNER_XFEA_PRICE_CODE_4_4, OWNER_XFEA_UNIT_AREA_4_4, OWNER_XFEA_ADDED_4_4, OWNER_XFEA_DESCR_4_4, OWNER_BLDG_NUMBER_5_4, OWNER_XFEA_LINE_NO_5_4, OWNER_XFEA_PRICE_CODE_5_4, OWNER_XFEA_UNIT_AREA_5_4, OWNER_XFEA_ADDED_5_4, OWNER_XFEA_DESCR_5_4, OWNER_BLDG_NUMBER_1_5, OWNER_XFEA_LINE_NO_1_5, OWNER_XFEA_PRICE_CODE_1_5, OWNER_XFEA_UNIT_AREA_1_5, OWNER_XFEA_ADDED_1_5, OWNER_XFEA_DESCR_1_5, OWNER_BLDG_NUMBER_2_5, OWNER_XFEA_LINE_NO_2_5, OWNER_XFEA_PRICE_CODE_2_5, OWNER_XFEA_UNIT_AREA_2_5, OWNER_XFEA_ADDED_2_5, OWNER_XFEA_DESCR_2_5, OWNER_BLDG_NUMBER_3_5, OWNER_XFEA_LINE_NO_3_5, OWNER_XFEA_PRICE_CODE_3_5, OWNER_XFEA_UNIT_AREA_3_5, OWNER_XFEA_ADDED_3_5, OWNER_XFEA_DESCR_3_5, OWNER_BLDG_NUMBER_4_5, OWNER_XFEA_LINE_NO_4_5, OWNER_XFEA_PRICE_CODE_4_5, OWNER_XFEA_UNIT_AREA_4_5, OWNER_XFEA_ADDED_4_5, OWNER_XFEA_DESCR_4_5, OWNER_BLDG_NUMBER_5_5, OWNER_XFEA_LINE_NO_5_5, OWNER_XFEA_PRICE_CODE_5_5, OWNER_XFEA_UNIT_AREA_5_5, OWNER_XFEA_ADDED_5_5, OWNER_XFEA_DESCR_5_5, OWNER_LEGAL_DESCR_1_1, OWNER_LEGAL_DESCR_2_1, OWNER_LEGAL_DESCR_3_1, OWNER_LEGAL_DESCR_4_1, OWNER_LEGAL_DESCR_5_1, OWNER_LEGAL_DESCR_1_2, OWNER_LEGAL_DESCR_2_2, OWNER_LEGAL_DESCR_3_2, OWNER_LEGAL_DESCR_4_2, OWNER_LEGAL_DESCR_5_2, OWNER_LEGAL_DESCR_1_3, OWNER_LEGAL_DESCR_2_3, OWNER_LEGAL_DESCR_3_3, OWNER_LEGAL_DESCR_4_3, OWNER_LEGAL_DESCR_5_3, OWNER_LEGAL_DESCR_1_4, OWNER_LEGAL_DESCR_2_4, OWNER_LEGAL_DESCR_3_4, OWNER_LEGAL_DESCR_4_4, OWNER_LEGAL_DESCR_5_4, OWNER_LEGAL_DESCR_1_5, OWNER_LEGAL_DESCR_2_5, OWNER_LEGAL_DESCR_3_5, OWNER_LEGAL_DESCR_4_5, OWNER_LEGAL_DESCR_5_5 )
To Top - Print - copybook.txt