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

DB2 LOAD
	FROM PROPERTY.dat OF ASC
	RECLEN=74
METHOD L (
	001 013,
	014 015,
	016 017,
	018 019,
	020 020,
	021 029,
	030 030,
	031 032,
	033 033,
	034 037,
	038 038,
	039 041,
	042 050,
	051 054,
	055 055,
	056 059,
	060 060,
	061 064,
	065 073
)
INSERT INTO PROPERTY (
	PROPERX_KEY,
	PROPERX_GRPCD,
	PROPERX_DISTRICT,
	LOTTYPE_TYPE_LOT,
	LOTTYPE_WET_LOT,
	LOTTYPE_SITE_VALUE,
	PROPERTYPE,
	PROPER_NBR,
	PROPER_CODE1,
	PROPER_AMOUNT,
	PROPER_CODE2,
	PROPER_PERCENT2,
	PROPER_VALUE,
	PROPERX_ZONE,
	PROPER_AGRI_CODE,
	PROPER_AGRI_YEAR,
	PROPER_EXCESS_FLAG,
	PROPER_EFF_YEAR,
	PROPER_REAPPRAISAL
)