Oracle Database Discussions

Hi All,

I am loading data from the mainframe to oracle database using sql loader.

I am getting the below error while loading the data.

Record 1: Rejected - Error on table STOCK_ITEM, column "PUR_UNITN".
ORA-01438: value larger than specified precision allowed for this column

The control file content is

LOAD DATA CHARACTERSET WE8EBCDIC500
INFILE OEPSITS.BIN "FIX1200"
APPEND
PRESERVE BLANKS
INTO TABLE STOCK_ITEM (
+"ID" POSITION(0001) CHAR(001),+
+"SYMBOL" POSITION(0004) CHAR(010),+
+"DESCRIPTION" POSITION(0017) CHAR(035),+
+"PARTNO" POSITION(0065) CHAR(040),+
+"MANUFACTURER" POSITION(0118) CHAR(010),+
+"NOUN" POSITION(0181) CHAR(015),+
+"MODIFIER" POSITION(0196) CHAR(015),+
+"SIZE1" POSITION(0211) CHAR(010),+
+"MODEL" POSITION(0231) CHAR(017),+
+"ACOND" POSITION(0248) CHAR(001),+
+"SUPPLIER" POSITION(0249) CHAR(010),+
+"TYPE" POSITION(0259) CHAR(001),+
+"COMMENTS1" POSITION(0260) CHAR(050),+
+"COMMENTS2" POSITION(0310) CHAR(050),+
+"PUR_UNITA" POSITION(0360) CHAR(002),+
+"PUR_UNITN" POSITION(0362) DECIMAL(005),+
+"ISS_UNITA" POSITION(0365) CHAR(002),+
+"ISS_UNITN" POSITION(0367) DECIMAL(005),+
+"PRICE_UNITA" POSITION(0370) CHAR(002),+
+"PRICE_UNITN" POSITION(0372) DECIMAL(009,004),+
+"STD_PACKAGE_A" POSITION(0377) CHAR(002),+
+"STD_PACKAGE_N" POSITION(0379) DECIMAL(005),+
+"PRICE_CUR" POSITION(0382) DECIMAL(011,004),+
+"PRICE_AVE" POSITION(0388) DECIMAL(011,004),+
+"STAX" POSITION(0394) CHAR(001),+
+"ON_ORDER" POSITION(0395) DECIMAL(007),+
+"RESERVED" POSITION(0399) DECIMAL(007),+
+"BACK_ORDER_QTY" POSITION(0403) DECIMAL(007),+
+"LOCATION1" POSITION(0407) CHAR(008),+
+"LOCATION2" POSITION(0415) CHAR(008),+
+"LOCATION3" POSITION(0423) CHAR(008),+
+"LOCATION4" POSITION(0431) CHAR(008),+
+"LOCATION5" POSITION(0439) CHAR(008),+
+"LOCATION6" POSITION(0447) CHAR(008),+
+"LOCATION7" POSITION(0455) CHAR(008),+
+"LOCATION8" POSITION(0463) CHAR(008),+
+"LOCATION9" POSITION(0471) CHAR(008),+
+"LOCATION10" POSITION(0479) CHAR(008),+
+"SEC_LOCATION1" POSITION(0487) CHAR(008),+
+"LOC1_QUAN" POSITION(0495) DECIMAL(009),+
+"LOC2_QUAN" POSITION(0500) DECIMAL(009),+
+"LOC3_QUAN" POSITION(0505) DECIMAL(009),+
+"LOC4_QUAN" POSITION(0510) DECIMAL(009),+
+"LOC5_QUAN" POSITION(0515) DECIMAL(009),+
+"LOC6_QUAN" POSITION(0520) DECIMAL(009),+
+"LOC7_QUAN" POSITION(0525) DECIMAL(009),+
+"LOC8_QUAN" POSITION(0530) DECIMAL(009),+
+"LOC9_QUAN" POSITION(0535) DECIMAL(009),+
+"LOC10_QUAN" POSITION(0540) DECIMAL(009),+
+"REORDER_PT_M" POSITION(0545) DECIMAL(007),+
+"REORDER_PT_C" POSITION(0549) DECIMAL(007),+
+"ORDER_QTY_M" POSITION(0553) DECIMAL(007),+
+"ORDER_QTY_C" POSITION(0557) DECIMAL(007),+
+"LEAD_TIME_DAYSM" POSITION(0561) DECIMAL(003),+
+"LEAD_TIME_DAYSC" POSITION(0563) DECIMAL(003),+
+"CALC_LT_DAYSM" POSITION(0565) DECIMAL(003),+
+"CALC_LT_DAYSC" POSITION(0567) DECIMAL(003),+
+"LAST_ORDER_DATE" POSITION(0569) DATE "RRMMDD"+
NULLIF("LAST_ORDER_DATE" = X"404040404040"),
+"LAST_ORDNO" POSITION(0575) CHAR(007),+
+"LAST_PO_SUPP" POSITION(0582) CHAR(003),+
+"LAST_PO_REL" POSITION(0585) CHAR(004),+
+"LAST_TRANS_DATE" POSITION(0589) CHAR(6),+
+"LAST_TRANS_NO" POSITION(0595) CHAR(009),+
+"LAST_TRANS_TYPE" POSITION(0604) CHAR(001),+
+"CYCLE_STATUS" POSITION(0605) CHAR(001),+
+"LOC1_CC_STATUS" POSITION(0606) CHAR(001),+
+"LOC2_CC_STATUS" POSITION(0607) CHAR(001),+
+"LOC3_CC_STATUS" POSITION(0608) CHAR(001),+
+"LOC4_CC_STATUS" POSITION(0609) CHAR(001),+
+"LOC5_CC_STATUS" POSITION(0610) CHAR(001),+
+"LOC6_CC_STATUS" POSITION(0611) CHAR(001),+
+"LOC7_CC_STATUS" POSITION(0612) CHAR(001),+
+"LOC8_CC_STATUS" POSITION(0613) CHAR(001),+
+"LOC9_CC_STATUS" POSITION(0614) CHAR(001),+
+"LOC10_CC_STATUS" POSITION(0615) CHAR(001),+
+"LAST_CYCLE_CNT_DATE" POSITION(0616) DATE "RRMMDD"+
NULLIF("LAST_CYCLE_CNT_DATE" = X"404040404040"),
+"LAST_CYCLE_CNT_QTY_1" POSITION(0622) DECIMAL(007),+
+"LAST_CYCLE_CNT_INIT_1" POSITION(0626) CHAR(006),+
+"LAST_CYCLE_CNT_QTY_2" POSITION(0632) DECIMAL(007),+
+"LAST_CYCLE_CNT_INIT_2" POSITION(0636) CHAR(006),+
+"LAST_CYCLE_CNT_QTY_3" POSITION(0642) DECIMAL(007),+
+"LAST_CYCLE_CNT_INIT_3" POSITION(0646) CHAR(006),+
+"CYCLE_CNT_FREQ" POSITION(0652) CHAR(001),+
+"REQ_INVENTORY" POSITION(0653) CHAR(001),+
+"MATERIAL" POSITION(0654) CHAR(015),+
+"USE_LY" POSITION(0669) DECIMAL(007),+
+"USE_LY2" POSITION(0673) DECIMAL(007),+
+"USE_LY3" POSITION(0677) DECIMAL(007),+
+"USE_LY4" POSITION(0681) DECIMAL(007),+
+"MONTH1_USE" POSITION(0685) DECIMAL(007),+
+"MONTH2_USE" POSITION(0689) DECIMAL(007),+
+"MONTH3_USE" POSITION(0693) DECIMAL(007),+
+"MONTH4_USE" POSITION(0697) DECIMAL(007),+
+"MONTH5_USE" POSITION(0701) DECIMAL(007),+
+"MONTH6_USE" POSITION(0705) DECIMAL(007),+
+"MONTH7_USE" POSITION(0709) DECIMAL(007),+
+"MONTH8_USE" POSITION(0713) DECIMAL(007),+
+"MONTH9_USE" POSITION(0717) DECIMAL(007),+
+"MONTH10_USE" POSITION(0721) DECIMAL(007),+
+"MONTH11_USE" POSITION(0725) DECIMAL(007),+
+"MONTH12_USE" POSITION(0729) DECIMAL(007),+
+"MARK_AS_DELETED" POSITION(0733) CHAR(001),+
+"REORDER" POSITION(0734) CHAR(001),+
+"VALUATION" POSITION(0735) DECIMAL(013,004),+
+"REC_ACCRUAL" POSITION(0742) DECIMAL(013,004),+
+"PRICE_PREV_AV" POSITION(0749) DECIMAL(011,004),+
+"BUYER" POSITION(0755) CHAR(004),+
+"ONLOAN" POSITION(0759) DECIMAL(005),+
+"INREPAIR" POSITION(0762) DECIMAL(003),+
+"REC_NOT_PAID" POSITION(0764) DECIMAL(007),+
+"BLANKET_ORDER_NO" POSITION(0768) CHAR(007),+
+"LAST_RECEIPT_NO" POSITION(0775) CHAR(007),+
+"LAST_RECEIPT_DATE" POSITION(0782) DECIMAL(007),+
+"STOCK_OUT" POSITION(0786) DECIMAL(007),+
+"STOCK_OUTS_LY" POSITION(0790) DECIMAL(007),+
+"ANNUAL_PROJ_USE" POSITION(0794) DECIMAL(007),+
+"EOQ_FLAG" POSITION(0798) CHAR(001),+
+"SAFETY_FACTOR" POSITION(0799) DECIMAL(005,002),+
+"EOQ_CALC" POSITION(0802) CHAR(001),+
+"EOP_CALC" POSITION(0803) CHAR(001),+
+"PROJ_USE_CALC" POSITION(0804) CHAR(001),+
+"ANALYST" POSITION(0805) CHAR(004),+
+"REGISTER_FLAG" POSITION(0809) CHAR(001),+
+"SAVE_PRICE_CUR" POSITION(0810) DECIMAL(011,004),+
+"SAVE_LOC1_QUAN" POSITION(0816) DECIMAL(007),+
+"SAVE_LOC2_QUAN" POSITION(0820) DECIMAL(007),+
+"SAVE_LOC3_QUAN" POSITION(0824) DECIMAL(007),+
+"SAVE_LOC4_QUAN" POSITION(0828) DECIMAL(007),+
+"SAVE_LOC5_QUAN" POSITION(0832) DECIMAL(007),+
+"SAVE_LOC6_QUAN" POSITION(0836) DECIMAL(007),+
+"SAVE_LOC7_QUAN" POSITION(0840) DECIMAL(007),+
+"SAVE_LOC8_QUAN" POSITION(0844) DECIMAL(007),+
+"SAVE_LOC9_QUAN" POSITION(0848) DECIMAL(007),+
+"SAVE_LOC10_QUAN" POSITION(0852) DECIMAL(007),+
+"OPENING_QTY" POSITION(0856) DECIMAL(009),+
+"ENDING_QTY" POSITION(0861) DECIMAL(009),+
+"LAST_ROLLOVER_DATE" POSITION(0866) DECIMAL(005),+
+"OUT_OF_BAL_YR" POSITION(0871) CHAR(002),+
+"OUT_OF_BAL_MTH" POSITION(0873) CHAR(002),+
+"INDEX_DESC" POSITION(0875) CHAR(035),+
+"QUALITY_CONTROL" POSITION(0910) CHAR(001),+
+"LAST_CYCLE_CNT_DATE_2" POSITION(0911) CHAR(006),+
+"LAST_CYCLE_CNT_DATE_3" POSITION(0917) CHAR(006),+
+"SETUP_DATE" POSITION(0923) CHAR(006),+
+"UPDATE_DATA_LAST_TRANS" POSITION(0929) CHAR(004),+
+"UPDATE_DATA_LAST_DATE" POSITION(0933) CHAR(005),+
+"UPDATE_DATA_LAST_USER" POSITION(0938) CHAR(006),+
+"REPAIR_FLAG" POSITION(0944) CHAR(001),+
+"REORDER_TRIGGER" POSITION(0945) CHAR(002),+
+"BLANKET_ORDER_2" POSITION(0947) CHAR(007),+
+"BLANKET_ORDER_3" POSITION(0954) CHAR(007),+
+"CHCA" POSITION(0961) CHAR(004),+
+"BRAND" POSITION(0965) CHAR(005),+
+"ISSUES_LY" POSITION(0970) DECIMAL(007),+
+"ISSUES_LY2" POSITION(0974) DECIMAL(007),+
+"ISSUES_LY3" POSITION(0978) DECIMAL(007),+
+"ISSUES_LY4" POSITION(0982) DECIMAL(007),+
+"MONTH1_ISSUES" POSITION(0986) DECIMAL(007),+
+"MONTH2_ISSUES" POSITION(0990) DECIMAL(007),+
+"MONTH3_ISSUES" POSITION(0994) DECIMAL(007),+
+"MONTH4_ISSUES" POSITION(0998) DECIMAL(007),+
+"MONTH5_ISSUES" POSITION(1002) DECIMAL(007),+
+"MONTH6_ISSUES" POSITION(1006) DECIMAL(007),+
+"MONTH7_ISSUES" POSITION(1010) DECIMAL(007),+
+"MONTH8_ISSUES" POSITION(1014) DECIMAL(007),+
+"MONTH9_ISSUES" POSITION(1018) DECIMAL(007),+
+"MONTH10_ISSUES" POSITION(1022) DECIMAL(007),+
+"MONTH11_ISSUES" POSITION(1026) DECIMAL(007),+
+"MONTH12_ISSUES" POSITION(1030) DECIMAL(007),+
+"YEAR_END_QTY" POSITION(1034) DECIMAL(009),+
+"YEAR_END_VALUE" POSITION(1039) DECIMAL(011,004),+
+"SAFETY_QTY" POSITION(1045) DECIMAL(007),+
+"SEASONAL_JAN_FLAG" POSITION(1049) CHAR(001),+
+"SEASONAL_FEB_FLAG" POSITION(1050) CHAR(001),+
+"SEASONAL_MAR_FLAG" POSITION(1051) CHAR(001),+
+"SEASONAL_APR_FLAG" POSITION(1052) CHAR(001),+
+"SEASONAL_MAY_FLAG" POSITION(1053) CHAR(001),+
+"SEASONAL_JUN_FLAG" POSITION(1054) CHAR(001),+
+"SEASONAL_JUL_FLAG" POSITION(1055) CHAR(001),+
+"SEASONAL_AUG_FLAG" POSITION(1056) CHAR(001),+
+"SEASONAL_SEP_FLAG" POSITION(1057) CHAR(001),+
+"SEASONAL_OCT_FLAG" POSITION(1058) CHAR(001),+
+"SEASONAL_NOV_FLAG" POSITION(1059) CHAR(001),+
+"SEASONAL_DEC_FLAG" POSITION(1060) CHAR(001),+
+"DRAW_ITEM" POSITION(1061) CHAR(004),+
+"DRAW_NUMBER" POSITION(1065) CHAR(040),+
+"VMD_CODE" POSITION(1105) CHAR(001),+
+"ACCOUNTING_ELEMENT" POSITION(1106) CHAR(004),+
+"AOD_CODE" POSITION(1110) CHAR(001),+
+"SEASONAL_PROC_JAN_FLAG" POSITION(1111) CHAR(001),+
+"SEASONAL_PROC_FEB_FLAG" POSITION(1112) CHAR(001),+
+"SEASONAL_PROC_MAR_FLAG" POSITION(1113) CHAR(001),+
+"SEASONAL_PROC_APR_FLAG" POSITION(1114) CHAR(001),+
+"SEASONAL_PROC_MAY_FLAG" POSITION(1115) CHAR(001),+
+"SEASONAL_PROC_JUN_FLAG" POSITION(1116) CHAR(001),+
+"SEASONAL_PROC_JUL_FLAG" POSITION(1117) CHAR(001),+
+"SEASONAL_PROC_AUG_FLAG" POSITION(1118) CHAR(001),+
+"SEASONAL_PROC_SEP_FLAG" POSITION(1119) CHAR(001),+
+"SEASONAL_PROC_OCT_FLAG" POSITION(1120) CHAR(001),+
+"SEASONAL_PROC_NOV_FLAG" POSITION(1121) CHAR(001),+
+"SEASONAL_PROC_DEC_FLAG" POSITION(1122) CHAR(001),+
+"TR_FLAG" POSITION(1127) CHAR(001),+
+"COMCD_TR" POSITION(1128) CHAR(8))+


the table structure in oracle database is

CREATE TABLE "STOCK_ITEM" (
+"ID" CHAR(001),+
+"SYMBOL" CHAR(010),+
+"DESCRIPTION" CHAR(035),+
+"PARTNO" CHAR(040),+
+"MANUFACTURER" CHAR(010),+
+"NOUN" CHAR(015),+
+"MODIFIER" CHAR(015),+
+"SIZE1" CHAR(010),+
+"MODEL" CHAR(017),+
+"ACOND" CHAR(001),+
+"SUPPLIER" CHAR(010),+
+"TYPE" CHAR(001),+
+"COMMENTS1" CHAR(050),+
+"COMMENTS2" CHAR(050),+
+"PUR_UNITA" CHAR(002),+
+"PUR_UNITN" NUMERIC(005),+
+"ISS_UNITA" CHAR(002),+
+"ISS_UNITN" NUMERIC(005),+
+"PRICE_UNITA" CHAR(002),+
+"PRICE_UNITN" NUMERIC(009,004),+
+"STD_PACKAGE_A" CHAR(002),+
+"STD_PACKAGE_N" NUMERIC(005),+
+"PRICE_CUR" NUMERIC(011,004),+
+"PRICE_AVE" NUMERIC(011,004),+
+"STAX" CHAR(001),+
+"ON_ORDER" NUMERIC(007),+
+"RESERVED" NUMERIC(007),+
+"BACK_ORDER_QTY" NUMERIC(007),+
+"LOCATION1" CHAR(008),+
+"LOCATION2" CHAR(008),+
+"LOCATION3" CHAR(008),+
+"LOCATION4" CHAR(008),+
+"LOCATION5" CHAR(008),+
+"LOCATION6" CHAR(008),+
+"LOCATION7" CHAR(008),+
+"LOCATION8" CHAR(008),+
+"LOCATION9" CHAR(008),+
+"LOCATION10" CHAR(008),+
+"SEC_LOCATION1" CHAR(008),+
+"LOC1_QUAN" NUMERIC(009),+
+"LOC2_QUAN" NUMERIC(009),+
+"LOC3_QUAN" NUMERIC(009),+
+"LOC4_QUAN" NUMERIC(009),+
+"LOC5_QUAN" NUMERIC(009),+
+"LOC6_QUAN" NUMERIC(009),+
+"LOC7_QUAN" NUMERIC(009),+
+"LOC8_QUAN" NUMERIC(009),+
+"LOC9_QUAN" NUMERIC(009),+
+"LOC10_QUAN" NUMERIC(009),+
+"REORDER_PT_M" NUMERIC(007),+
+"REORDER_PT_C" NUMERIC(007),+
+"ORDER_QTY_M" NUMERIC(007),+
+"ORDER_QTY_C" NUMERIC(007),+
+"LEAD_TIME_DAYSM" NUMERIC(003),+
+"LEAD_TIME_DAYSC" NUMERIC(003),+
+"CALC_LT_DAYSM" NUMERIC(003),+
+"CALC_LT_DAYSC" NUMERIC(003),+
+"LAST_ORDER_DATE" DATE,+
+"LAST_ORDNO" CHAR(007),+
+"LAST_PO_SUPP" CHAR(003),+
+"LAST_PO_REL" CHAR(004),+
+"LAST_TRANS_DATE" CHAR(006),+
+"LAST_TRANS_NO" CHAR(009),+
+"LAST_TRANS_TYPE" CHAR(001),+
+"CYCLE_STATUS" CHAR(001),+
+"LOC1_CC_STATUS" CHAR(001),+
+"LOC2_CC_STATUS" CHAR(001),+
+"LOC3_CC_STATUS" CHAR(001),+
+"LOC4_CC_STATUS" CHAR(001),+
+"LOC5_CC_STATUS" CHAR(001),+
+"LOC6_CC_STATUS" CHAR(001),+
+"LOC7_CC_STATUS" CHAR(001),+
+"LOC8_CC_STATUS" CHAR(001),+
+"LOC9_CC_STATUS" CHAR(001),+
+"LOC10_CC_STATUS" CHAR(001),+
+"LAST_CYCLE_CNT_DATE" DATE,+
+"LAST_CYCLE_CNT_QTY_1" NUMERIC(007),+
+"LAST_CYCLE_CNT_INIT_1" CHAR(006),+
+"LAST_CYCLE_CNT_QTY_2" NUMERIC(007),+
+"LAST_CYCLE_CNT_INIT_2" CHAR(006),+
+"LAST_CYCLE_CNT_QTY_3" NUMERIC(007),+
+"LAST_CYCLE_CNT_INIT_3" CHAR(006),+
+"CYCLE_CNT_FREQ" CHAR(001),+
+"REQ_INVENTORY" CHAR(001),+
+"MATERIAL" CHAR(015),+
+"USE_LY" NUMERIC(007),+
+"USE_LY2" NUMERIC(007),+
+"USE_LY3" NUMERIC(007),+
+"USE_LY4" NUMERIC(007),+
+"MONTH1_USE" NUMERIC(007),+
+"MONTH2_USE" NUMERIC(007),+
+"MONTH3_USE" NUMERIC(007),+
+"MONTH4_USE" NUMERIC(007),+
+"MONTH5_USE" NUMERIC(007),+
+"MONTH6_USE" NUMERIC(007),+
+"MONTH7_USE" NUMERIC(007),+
+"MONTH8_USE" NUMERIC(007),+
+"MONTH9_USE" NUMERIC(007),+
+"MONTH10_USE" NUMERIC(007),+
+"MONTH11_USE" NUMERIC(007),+
+"MONTH12_USE" NUMERIC(007),+
+"MARK_AS_DELETED" CHAR(001),+
+"REORDER" CHAR(001),+
+"VALUATION" NUMERIC(013,004),+
+"REC_ACCRUAL" NUMERIC(013,004),+
+"PRICE_PREV_AV" NUMERIC(011,004),+
+"BUYER" CHAR(004),+
+"ONLOAN" NUMERIC(005),+
+"INREPAIR" NUMERIC(003),+
+"REC_NOT_PAID" NUMERIC(007),+
+"BLANKET_ORDER_NO" CHAR(007),+
+"LAST_RECEIPT_NO" CHAR(007),+
+"LAST_RECEIPT_DATE" NUMERIC(007),+
+"STOCK_OUT" NUMERIC(007),+
+"STOCK_OUTS_LY" NUMERIC(007),+
+"ANNUAL_PROJ_USE" NUMERIC(007),+
+"EOQ_FLAG" CHAR(001),+
+"SAFETY_FACTOR" NUMERIC(005,002),+
+"EOQ_CALC" CHAR(001),+
+"EOP_CALC" CHAR(001),+
+"PROJ_USE_CALC" CHAR(001),+
+"ANALYST" CHAR(004),+
+"REGISTER_FLAG" CHAR(001),+
+"SAVE_PRICE_CUR" NUMERIC(011,004),+
+"SAVE_LOC1_QUAN" NUMERIC(007),+
+"SAVE_LOC2_QUAN" NUMERIC(007),+
+"SAVE_LOC3_QUAN" NUMERIC(007),+
+"SAVE_LOC4_QUAN" NUMERIC(007),+
+"SAVE_LOC5_QUAN" NUMERIC(007),+
+"SAVE_LOC6_QUAN" NUMERIC(007),+
+"SAVE_LOC7_QUAN" NUMERIC(007),+
+"SAVE_LOC8_QUAN" NUMERIC(007),+
+"SAVE_LOC9_QUAN" NUMERIC(007),+
+"SAVE_LOC10_QUAN" NUMERIC(007),+
+"OPENING_QTY" NUMERIC(009),+
+"ENDING_QTY" NUMERIC(009),+
+"LAST_ROLLOVER_DATE" NUMERIC(005),+
+"OUT_OF_BAL_YR" CHAR(002),+
+"OUT_OF_BAL_MTH" CHAR(002),+
+"INDEX_DESC" CHAR(035),+
+"QUALITY_CONTROL" CHAR(001),+
+"LAST_CYCLE_CNT_DATE_2" CHAR(006),+
+"LAST_CYCLE_CNT_DATE_3" CHAR(006),+
+"SETUP_DATE" CHAR(006),+
+"UPDATE_DATA_LAST_TRANS" CHAR(004),+
+"UPDATE_DATA_LAST_DATE" CHAR(005),+
+"UPDATE_DATA_LAST_USER" CHAR(006),+
+"REPAIR_FLAG" CHAR(001),+
+"REORDER_TRIGGER" CHAR(002),+
+"BLANKET_ORDER_2" CHAR(007),+
+"BLANKET_ORDER_3" CHAR(007),+
+"CHCA" CHAR(004),+
+"BRAND" CHAR(005),+
+"ISSUES_LY" NUMERIC(007),+
+"ISSUES_LY2" NUMERIC(007),+
+"ISSUES_LY3" NUMERIC(007),+
+"ISSUES_LY4" NUMERIC(007),+
+"MONTH1_ISSUES" NUMERIC(007),+
+"MONTH2_ISSUES" NUMERIC(007),+
+"MONTH3_ISSUES" NUMERIC(007),+
+"MONTH4_ISSUES" NUMERIC(007),+
+"MONTH5_ISSUES" NUMERIC(007),+
+"MONTH6_ISSUES" NUMERIC(007),+
+"MONTH7_ISSUES" NUMERIC(007),+
+"MONTH8_ISSUES" NUMERIC(007),+
+"MONTH9_ISSUES" NUMERIC(007),+
+"MONTH10_ISSUES" NUMERIC(007),+
+"MONTH11_ISSUES" NUMERIC(007),+
+"MONTH12_ISSUES" NUMERIC(007),+
+"YEAR_END_QTY" NUMERIC(009),+
+"YEAR_END_VALUE" NUMERIC(011,004),+
+"SAFETY_QTY" NUMERIC(007),+
+"SEASONAL_JAN_FLAG" CHAR(001),+
+"SEASONAL_FEB_FLAG" CHAR(001),+
+"SEASONAL_MAR_FLAG" CHAR(001),+
+"SEASONAL_APR_FLAG" CHAR(001),+
+"SEASONAL_MAY_FLAG" CHAR(001),+
+"SEASONAL_JUN_FLAG" CHAR(001),+
+"SEASONAL_JUL_FLAG" CHAR(001),+
+"SEASONAL_AUG_FLAG" CHAR(001),+
+"SEASONAL_SEP_FLAG" CHAR(001),+
+"SEASONAL_OCT_FLAG" CHAR(001),+
+"SEASONAL_NOV_FLAG" CHAR(001),+
+"SEASONAL_DEC_FLAG" CHAR(001),+
+"DRAW_ITEM" CHAR(004),+
+"DRAW_NUMBER" CHAR(040),+
+"VMD_CODE" CHAR(001),+
+"ACCOUNTING_ELEMENT" CHAR(004),+
+"AOD_CODE" CHAR(001),+
+"SEASONAL_PROC_JAN_FLAG" CHAR(001),+
+"SEASONAL_PROC_FEB_FLAG" CHAR(001),+
+"SEASONAL_PROC_MAR_FLAG" CHAR(001),+
+"SEASONAL_PROC_APR_FLAG" CHAR(001),+
+"SEASONAL_PROC_MAY_FLAG" CHAR(001),+
+"SEASONAL_PROC_JUN_FLAG" CHAR(001),+
+"SEASONAL_PROC_JUL_FLAG" CHAR(001),+
+"SEASONAL_PROC_AUG_FLAG" CHAR(001),+
+"SEASONAL_PROC_SEP_FLAG" CHAR(001),+
+"SEASONAL_PROC_OCT_FLAG" CHAR(001),+
+"SEASONAL_PROC_NOV_FLAG" CHAR(001),+
+"SEASONAL_PROC_DEC_FLAG" CHAR(001),+
+"TR_FLAG" CHAR(001),+
+"COMCD_TR" CHAR(008),+
CONSTRAINT STOCK_ITEM
PRIMARY KEY
+("SYMBOL"));+


The data type in the mainframe is like below

PUR_UNITN PIC S9(5) COMP-3

Please help us to reslove thsi

thanks in advance

Regards
Arun