hello,
now i m posting here my complete information, input record format , my current table fields and its type and error log. please review this and tell me whats wrong in this. thanks in advance.
INPUT RECORD FORMAT 01 ACCOUNT-REC.
02 ACDATE1 PIC X(8).
02 ACSTRT1 PIC S9(7) COMP-3.
02 ACSTOP1 PIC S9(7) COMP-3.
02 PCUSER PIC X(16).
02 JNAME PIC X(8).
02 JNUMB PIC S9(4) COMP.
02 RECTYPE PIC X.
02 CANCCODE PIC XX.
02 PRNTRADD PIC XXX.
02 FILLER PIC X(10).
02 PRNTDCOP PIC 9(2) COMP.
02 FILLER PIC X(8).
02 PRNTDPAG PIC 9(4) COMP.
02 FILLER PIC X(16).
02 EXCNODE PIC X(2).
02 EXUSER PIC X(8).
02 FILLER PIC X(10).
02 LSTNODE PIC X(2).
02 FILLER PIC X(12).
02 PARTID PIC X(2).
02 FILLER PIC X(2).
02 JDURAT PIC 9(8) COMP.
02 JPHASE PIC X(8).
02 FILLER PIC X(4).
02 JCPUTM PIC 9(8) COMP.
02 JOVHTM PIC 9(8) COMP.
02 JWAIT PIC 9(8) COMP.
02 FILLER PIC X(148).
TABLE FIELDS AND DATA TYPE CNAME COLTYPE LENGTH SYSLENGTH
------------------ ----------- ---------- --------------
CANC_CODE CHAR 4 4
EXUSER CHAR 8 8
JOB_CPUTM INTEGER 4
JOB_DATE CHAR 8 8
JOB_DURAT INTEGER 4
JOB_ENDTM DECIMAL (7 , 0) 1792
JOB_NAME CHAR 8 8
JOB_NUMB SMALLINT 2
JOB_OVHTM INTEGER 4
JOB_PHASE CHAR 8 8
JOB_STRTTM DECIMAL (7 , 0) 1792
MACHINE_ID CHAR 2 2
PART_ID CHAR 2 2
PRINTER_ADD CHAR 3 3
PRNTD_COP SMALLINT 2
PRNTD_PAG SMALLINT 2
RECTYPE CHAR 1 1
ERROR I GOT
------> DATALOAD TABLE (JOB_ACCNTNG)
------> JOB_DATE 1-8
------> JOB_STRTTM 9-12
------> JOB_ENDTM 13-16
------> JOB_NAME 33-40
------> RECTYPE 43
------> CANC_CODE 44-45
------> MACHINE_ID 87-88
------> EXUSER 89-96
------> PART_ID 121-122
------> INFILE (SYS004 BLKSZ(300) )
ARI0852I DATALOAD TABLE processing started.
ARI0868I DNAME=SYS004 RECFM=F RECSZ=300 BLKSIZE=300
ARI0866E Input record data field error:
Column = JOB_STRTTM Input Record Count = 1
(000001): F1F061F3F061F1F00154641F0154654F40404040404040404040404040404040C4C2F2C3D6D3C44017B9C510800000000000F8F9000000
(000056): 52000000000003002500DD00BD00000000D7E6D9E5E2C5F340D7E6D9E5E2C5F340C1D4C5D940404040C4C2F2C3D6D3C4404040404040C3
(000111): D6D3C440E2E3C1D9E3E4C6F810D300000F98C1D9C9E2D8D3C4E200183000000001F70000009F000001130B00000000680FEC0000000A03
(000166): 0C0000000E0B01000000170B050000219C0FEE0000007D2040404040404040400000000300000000000000000000000000000000000000
(000221): 00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
(000276): 00000000000000000000000000000000000000000000000000
ARI0857E DATALOAD processing unsuccessful.
ARI8998I ...Begin ROLLBACK processing.
ARI0811I ...ROLLBACK of any database changes successful.
ARI0813I ...Suspend command execution:
AUTOCOMMIT = OFF ERRORMODE = ON
------> COMMIT WORK;
ARI0819I ...Command not processed: ERRORMODE = ON
ARI0802I End of command file input.
ARI0807E ...Errors occurred during command processing.
ARI0808I DBS processing completed: 24/12/10 15:11:13.
1S55I LAST RETURN CODE WAS 0008
EOJ DATALOD MAX.RETURN CODE=0008 DATE 24/12/2010
and more thing JNUMB FIELD in my input field contains data from (0000-FFFF) in decimal(0-65535). it beyond the range of SMALLINT type. thats y i chose INT as my first choice for JOB_NUMB field in my table. but bcoz of your replies i recreated my table as according to the last reply by GuyC.
but no use. m still there where we started this thread.
any suggestion wud b appreciable.