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

DB2 LOAD
	FROM LAND.dat OF ASC
	RECLEN=104
METHOD L (
	001 013,
	014 015,
	016 017,
	018 019,
	020 020,
	021 029,
	030 030,
	031 032,
	033 062,
	063 063,
	064 067,
	068 068,
	069 071,
	072 080,
	081 084,
	085 085,
	086 089,
	090 090,
	091 094,
	095 103
)
INSERT INTO LAND (
	PROPERX_KEY,
	PROPERX_GRPCD,
	PROPERX_DISTRICT,
	LOTTYPE_TYPE_LOT,
	LOTTYPE_WET_LOT,
	LOTTYPE_SITE_VALUE,
	PROPERTYPE,
	PROPER_NBR,
	O_UNPACKED,
	PROPER_CODE1,
	PROPER_AMOUNT1,
	PROPER_CODE2,
	PROPER_PERCENT2,
	PROPER_VALUE,
	PROPERX_ZONE,
	PROPER_AGRI_CODE,
	PROPER_AGRI_YEAR,
	PROPER_EXCESS_FLAG,
	PROPER_EFF_YEAR,
	PROPER_REAPPRAISAL
)