---
---   DB2 Load File For HOMES Table
---   Created on: 23-MAY-2020 10:46 AM
---   Created by: +1Copybook (C)
---

DB2 LOAD
	FROM HOMES.dat OF ASC
	RECLEN=174
METHOD L (
	001 013,
	014 015,
	016 017,
	018 019,
	020 020,
	021 021,
	022 025,
	026 034,
	035 043,
	044 052,
	053 061,
	062 068,
	069 073,
	074 078,
	079 083,
	084 085,
	086 086,
	087 087,
	088 088,
	089 097,
	098 102,
	103 109,
	110 118,
	119 121,
	122 124,
	125 134,
	135 136,
	137 137,
	138 146,
	147 155,
	156 164,
	165 173
)
INSERT INTO HOMES (
	HOMES_KEY,
	HOMES_GRPCD,
	HOME_A_NUMBER,
	HOME_B_KEY,
	HOME_A_CHANGE_FLAG,
	HOME_A_SITE_FLAG,
	HOME_A_SITE_VALUE_CODER,
	HOME_A_SITE_VALUE,
	HOME_A_CURR_VALUE,
	HOME_A_XFEA_VALUE,
	HOME_A_TOTAL_SQFTG,
	HOME_A_BEDROOMS,
	HOME_A_BATHS,
	HOME_A_HALF_BATHS,
	HOME_A_UNITS,
	HOME_A_FLOORS,
	HOME_B_CHANGE_FLAG,
	HOME_B_CODE,
	HOME_B_ADD_SQFTG_FLAG,
	HOME_B_VALUE,
	HOME_B_ITEMS,
	HOME_B_SPECIAL,
	HOME_B_TOTAL_SQFTG,
	HOME_B_PTS_GRADE,
	HOME_B_GRADE,
	HOME_B_ADDITION,
	HOMES_X_DISTRICT,
	HOME_B_NC_FLAG,
	HOME_B_NC_NEW,
	HOME_B_NC_ADD,
	HOME_B_NC_DEMO,
	HOME_B_REAPPRAISAL
)