When increasing table length, a LOAD with MISMATCH=IGNORE getting error DB13008E INPUT RECORD LENGTH nnn DOES NOT MATCH THE TABLE ttt RECORD LENGTH

Document ID : KB000008348
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

I changed the length of table AAA from 200 to 300.

When running a DBUTLTY LOAD with MISMATCH=IGNORE, I'm getting error:

DB13008E INPUT RECORD LENGTH 200 DOES NOT MATCH THE TABLE AAA RECORD LENGTH 300

 

Resolution:

The DBUTLTY LOAD function with MISMATCH=IGNORE is only valid for use with compressed records. 

When changing the table definition by adding fields, the correct way to reformat the record is to use the DDRMFLM dictionary utility.

 

Additional Information: