DBSU DATALOAD problem
Posted: Wed Dec 15, 2010 5:52 pm
hi every one,
i am facing a problem while loading data from sequential file reside in TAPE into the DB2 Table using DBSU DATALOAD Command.
the problem is, input data is of type binary and target field is SQL INTEGER and it can't be convert binary field into integer.
DBSU book tells this utility automatically convert binary field into integer.
my running environment is ;
DB2 Server for VSE/VM version 7.5 under the Operating System VSE 4.2
and the error i got
[color=#4000FF]ARI0852I DATALOAD TABLE processing started.
ARI0868I DNAME=SYS004 RECFM=F RECSZ=300 BLKSIZE=300
ARI0866E Input record data field error:
Column = JOB_NUMB Input Record Count = 1
(000001): F1F061F3F061F1F00154641F0154654F40404040404040404040404040404040C4C2F2
(000056): 52000000000003002500DD00BD00000000D7E6D9E5E2C5F340D7E6D9E5E2C5F340C1D4
(000111): D6D3C440E2E3C1D9E3E4C6F810D300000F98C1D9C9E2D8D3C4E200183000000001F700
(000166): 0C0000000E0B01000000170B050000219C0FEE0000007D204040404040404040000000
(000221): 0000000000000000000000000000000000000000000000000000000000000000000000
(000276): 00000000000000000000000000000000000000000000000000 [/color]
please help me on this .
i am facing a problem while loading data from sequential file reside in TAPE into the DB2 Table using DBSU DATALOAD Command.
the problem is, input data is of type binary and target field is SQL INTEGER and it can't be convert binary field into integer.
DBSU book tells this utility automatically convert binary field into integer.
my running environment is ;
DB2 Server for VSE/VM version 7.5 under the Operating System VSE 4.2
and the error i got
[color=#4000FF]ARI0852I DATALOAD TABLE processing started.
ARI0868I DNAME=SYS004 RECFM=F RECSZ=300 BLKSIZE=300
ARI0866E Input record data field error:
Column = JOB_NUMB Input Record Count = 1
(000001): F1F061F3F061F1F00154641F0154654F40404040404040404040404040404040C4C2F2
(000056): 52000000000003002500DD00BD00000000D7E6D9E5E2C5F340D7E6D9E5E2C5F340C1D4
(000111): D6D3C440E2E3C1D9E3E4C6F810D300000F98C1D9C9E2D8D3C4E200183000000001F700
(000166): 0C0000000E0B01000000170B050000219C0FEE0000007D204040404040404040000000
(000221): 0000000000000000000000000000000000000000000000000000000000000000000000
(000276): 00000000000000000000000000000000000000000000000000 [/color]
please help me on this .