DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQL Loader - ERROR - Field in data file exceeds maximum length

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598

    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.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool


    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
  •  


Click Here to Expand Forum to Full Width