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

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

book

Article ID: 8348

calendar_today

Updated On:

Products

Datacom DATACOM - AD CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services CA ECOMETER SERVER COMPONENT FOC Easytrieve Report Generator for Common Services INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA ON DEMAND PORTAL CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET Xpertware

Issue/Introduction

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

 

Environment

Release: DATABB00200-14-Datacom/AD
Component:

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

See DDRMFLM - Converting Field Definitions in DocOps