LAND Table Row Storage Size
Table - Sorted Table - Copybook - Create Table - Load File - Row Size - Back To Table Index

Column NameData TypeBytes Used
PROPERX_KEY BIGINT8
PROPERX_GRPCD SMALLINT10
PROPERX_DISTRICT SMALLINT12
LOTTYPE_TYPE_LOT SMALLINT14
LOTTYPE_WET_LOT VARCHAR(1)15
LOTTYPE_SITE_VALUE INT19
PROPERTYPE VARCHAR(1)20
PROPER_NBR VARCHAR(2)22
O_UNPACKED VARCHAR(30)52
PROPER_CODE1 SMALLINT54
PROPER_AMOUNT1 SMALLINT56
PROPER_CODE2 SMALLINT58
PROPER_PERCENT2 DECIMAL(4,2)62
PROPER_VALUE INT66
PROPERX_ZONE VARCHAR(4)70
PROPER_AGRI_CODE VARCHAR(1)71
PROPER_AGRI_YEAR SMALLINT73
PROPER_EXCESS_FLAG VARCHAR(1)74
PROPER_EFF_YEAR SMALLINT76
PROPER_REAPPRAISAL INT80

20 columns are defined.

To Top - Print

Output Generated By +1DataElements From +1 Software Engineering LLC.
Created on: 23-MAY-2020 10:46 AM