-
SQL Loader - ERROR - Field in data file exceeds maximum length
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
Cheers!
OraKid.
-
In the controlfile, you need to list first the physical fields in the order in which they appear in the file. Afterwards, list the sequences and constants; for example:
Code:
RECORD_NR INTEGER EXTERNAL,
NODE_ID CHAR,
MMSC_ENTITY CHAR,
...etc...(to last field in file record),
EDW_MMSC_ID SEQUENCE(MAX,1) ,
SOURCE_SYSTEM_ID CONSTANT '016' )
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|