error masage
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: error masage

  1. #1
    Join Date
    Mar 2001
    Posts
    15
    Does anybody know what this errror "Column not found before end of logical record" means in SQL LOADER.
    Thanx.

  2. #2
    Join Date
    Mar 2001
    Posts
    63
    Sounds to me like you had your control file set to look for X number of columns, and it only found X-1 columns in the logical record.

    I think it pretty much only does that when using a file enclosed by characters, and not when using positional notation.

    Nevertheless, the fix is simple... use TRAILING NULLCOLS and you should be fine.


  3. #3
    Join Date
    Mar 2001
    Posts
    15
    How do I use TRAILING NULLCOLS? Where do I put it in?
    Could you provide me with an example.
    Thanx.

  4. #4
    Join Date
    Mar 2001
    Posts
    63
    load data
    INFILE 'XXX.dat'
    INTO TABLE XXX
    FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
    TRAILING NULLCOLS


    It's just another line to put into the header of the control file.


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