Hi,

I am getting the following error:
Record 47: Rejected - Error on table MMSC_TMP, column RECORD_NR.
Field in data file exceeds maximum length

This my table MMSC_TMP
Column is RECORD_NR Column datatype is NUMBER of 10

This is my control file (first 5 columns)

EDW_MMSC_ID SEQUENCE(MAX,1) ,
SOURCE_SYSTEM_ID CONSTANT '016' ,
RECORD_NR INTEGER EXTERNAL,
NODE_ID CHAR,
MMSC_ENTITY CHAR,

When I check the internet they asked to add CHAR(4000).


Now I am struck with the syntax. Dont know how to add this CHAR(4000)
RECORD_NR INTEGER EXTERNAL,

revert please

Many thanks