PROPERTY Copybook Mapping
Table - Sorted Table - Copybook - Create Table - Load File - Row Size - Back To Table Index
Red- OCCURS seen.
Blue- Highlights DATE columns.
Brown- Highlights potential DATETIME or MONEY columns.
Orange- Redefine columns, EJECT, or SKIP.
Purple- Override columns and data types.
Green- Comments.
 Copybook DefinitionDB2 Column NamePosition#Bytes Create Table Data Type
1.
       01  RECORD.
     
2.
           02  PROPERX-KEY                     PIC  9(13).
PROPERX_KEY POSITION(001:013)
13
BIGINT
3.
           02  PROPERX-GRPCD                   PIC  9(02).
PROPERX_GRPCD POSITION(014:015)
2
SMALLINT
4.
           02  PROPERX-DISTRICT                PIC  9(02).
PROPERX_DISTRICT POSITION(016:017)
2
SMALLINT
5.
           02  LOTTYPE-TYPE-LOT                 PIC  9(02).
LOTTYPE_TYPE_LOT POSITION(018:019)
2
SMALLINT
6.
           02  LOTTYPE-WET-LOT                  PIC  X(01).
LOTTYPE_WET_LOT POSITION(020:020)
1
VARCHAR(1)
7.
           02  LOTTYPE-SITE-VALUE               PIC S9(09).
LOTTYPE_SITE_VALUE POSITION(021:029)
9
INT
8.
             02  PROPERTYPE                      PIC X.
PROPERTYPE POSITION(030:030)
1
VARCHAR(1)
9.
             02  PROPER-NBR                      PIC XX.
PROPER_NBR POSITION(031:032)
2
VARCHAR(2)
10.
             02  PROPER-CODE1                    PIC  9(01).
PROPER_CODE1 POSITION(033:033)
1
SMALLINT
11.
             02  PROPER-AMOUNT                   PIC S9(04).
PROPER_AMOUNT POSITION(034:037)
4
SMALLINT
12.
             02  PROPER-PERCENT1 REDEFINES O-LINE-AMOUNT1
     
13.
                                                     PIC S9(01)V9(03).
     
14.
             02  PROPER-CODE2                    PIC  9(01).
PROPER_CODE2 POSITION(038:038)
1
SMALLINT
15.
             02  PROPER-PERCENT2                 PIC S9(01)V9(02).
PROPER_PERCENT2 POSITION(039:041)
3
DECIMAL(4,2)
16.
             02  PROPER-VALUE                    PIC S9(09).
PROPER_VALUE POSITION(042:050)
9
INT
17.
             02  PROPERX-ZONE                    PIC  X(4).
PROPERX_ZONE POSITION(051:054)
4
VARCHAR(4)
18.
             02  PROPER-AGRI-CODE                PIC  X(01).
PROPER_AGRI_CODE POSITION(055:055)
1
VARCHAR(1)
19.
             02  PROPER-AGRI-YEAR                PIC  9(04).
PROPER_AGRI_YEAR POSITION(056:059)
4
SMALLINT
20.
             02  PROPER-EXCESS-FLAG              PIC  X(01).
PROPER_EXCESS_FLAG POSITION(060:060)
1
VARCHAR(1)
21.
             02  PROPER-EFF-YEAR                 PIC  9(04).
PROPER_EFF_YEAR POSITION(061:064)
4
SMALLINT
22.
             02  PROPER-REAPPRAISAL              PIC S9(09).
PROPER_REAPPRAISAL POSITION(065:073)
9
INT
23.
     
24.
OWNER TABLE
     

Copybook defines 73 bytes of data. Line delimiters are not in totals.

To Top - Print - copybook.txt

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