Re: Help ! SQL Loader for Novell : Miss the last line
Date: 1995/07/02
Message-ID: <dscott-0207951606180001_at_dscott.is.net>#1/1
In article <3sss57$dlp_at_Tandem.CAM.ORG>, Francois-Legault <flegaul_at_cam.org> wrote:
> I am trying to load a file with fields delimited with , and enclosed
> with ". When the last line of the file is empty there is no problem.
> When I try loading a file where the last line is not empty, that line is
> not loaded and I miss one record.
>
> I really need some help here because I looked in all the books and I
> found nothing specific about this. I hope not to create a program just
> to add a blank line at the end. I tried with TRAILING NULLCOLLS but it
> did not change anything to the situation.
>
I've had the same problem a number of times. What happens is that the
CR/LF combiination is delimiting the record; all you need to do is add a
blank line to the end of the file OR use "fix 999" (where 999 is your
record length in bytes for a FIXED length record) in the OPTIONS string.
Experiment, have fun, and good luck!!!
David Scott
...how can I keep from singing?
email: dscott_at_is.net
Received on Sun Jul 02 1995 - 00:00:00 CEST