Table -
Sorted Table -
Copybook -
Control File -
Create Table -
Sorted Create Table -
Row Size -
Back To Table Index
---
--- SQL*Loader Control File For PROPERTY Table
--- Created on: 23-MAY-2020 3:50 PM
--- Created by: +1Copybook (C)
---
OPTIONS(DIRECT=TRUE)
UNRECOVERABLE LOAD DATA
INFILE '../DATA/PROPERTY.txt'
BADFILE 'PROPERTY.bad'
APPEND
INTO TABLE PROPERTY
(
PROPERX_KEY POSITION(001:013) INTEGER EXTERNAL NULLIF (PROPERX_KEY=BLANKS),
PROPERX_GRPCD POSITION(014:015) INTEGER EXTERNAL NULLIF (PROPERX_GRPCD=BLANKS),
PROPERX_DISTRICT POSITION(016:017) INTEGER EXTERNAL NULLIF (PROPERX_DISTRICT=BLANKS),
LOTTYPE_TYPE_LOT POSITION(018:019) INTEGER EXTERNAL NULLIF (LOTTYPE_TYPE_LOT=BLANKS),
LOTTYPE_WET_LOT POSITION(020:020) CHAR,
LOTTYPE_SITE_VALUE POSITION(021:029) DECIMAL EXTERNAL NULLIF (LOTTYPE_SITE_VALUE=blanks),
PROPERTYPE POSITION(030:030) CHAR,
PROPER_NBR POSITION(031:032) CHAR,
PROPER_CODE1 POSITION(033:033) INTEGER EXTERNAL NULLIF (PROPER_CODE1=BLANKS),
PROPER_AMOUNT POSITION(034:037) DECIMAL EXTERNAL NULLIF (PROPER_AMOUNT=blanks),
PROPER_CODE2 POSITION(038:038) INTEGER EXTERNAL NULLIF (PROPER_CODE2=BLANKS),
PROPER_PERCENT2 POSITION(039:041) DECIMAL EXTERNAL ":PROPER_PERCENT2/100",
PROPER_VALUE POSITION(042:050) DECIMAL EXTERNAL NULLIF (PROPER_VALUE=blanks),
PROPERX_ZONE POSITION(051:054) CHAR,
PROPER_AGRI_CODE POSITION(055:055) CHAR,
PROPER_AGRI_YEAR POSITION(056:059) INTEGER EXTERNAL NULLIF (PROPER_AGRI_YEAR=BLANKS),
PROPER_EXCESS_FLAG POSITION(060:060) CHAR,
PROPER_EFF_YEAR POSITION(061:064) INTEGER EXTERNAL NULLIF (PROPER_EFF_YEAR=BLANKS),
PROPER_REAPPRAISAL1 POSITION(065:067) DECIMAL EXTERNAL NULLIF (PROPER_REAPPRAISAL1=blanks),
PROPER_REAPPRAISAL2 POSITION(068:071) DECIMAL EXTERNAL NULLIF (PROPER_REAPPRAISAL2=blanks),
PROPER_INSPECT_CODE POSITION(072:073) INTEGER EXTERNAL NULLIF (PROPER_INSPECT_CODE=BLANKS)
)
To Top - Print - copybook.txt