I’m looking for some help on moving data from DB2 z/OS to DB2 on AIX. I must be doing something wrong as I believe this should work. DSNTIAUL is unloading data into a file:
000023 SPL < 2004
000024 SPL * 2004
I’m now using the INGEST utility to read this file using the following control cards:
ingest from file input.DAT format positional
$JOB_GROUP POSITION(1:6) CHAR(6),
$JOB_GRP_NUM position(7:8) DECIMAL(2,0) external,
$PROC_PRIORITY_NUM position(9:10) DECIMAL (3,0) external ,
$FRMT_INDCTR_CD position(11) CHAR(1),
$FILE_TYPE_CD position(12) CHAR(3)
insert into DB2INST1.NEW_TIPABPT
values ( $JOB_GROUP, $JOB_GRP_NUM, $PROC_PRIORITY_NUM, $FRMT_INDCTR_CD, $FILE_TYPE_CD);
When I run this utility, I get the following error:
SQL2922I The following warning or error occurred while formatting data from
line "37" of input file "TEST.IP.E049403.T41BPTUL.EOL.DAT".
SQL2953N The field value in line "37" starting at byte position "7" cannot be
converted to the value type: "DECIMAL".
The INGEST utility says is can handle delimited and positional data. I’ve set this up for positional. However, when it gets to the 7th byte of the mainframe file, it cannot interpret this data. I originally had the file sent from z/OS to the AIX server using binary, but found out this had to be text format.
Any idea what I might be doing wrong?