Re: Repost: SQLLOADER problem

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Sun, 24 Mar 2002 10:23:13 GMT
Message-ID: <3c9da837.9625745@news.freeler.nl>

Do you by any chance ftp the logfile from Unix to NT in binary format? If so: on UNIX lines are separated with the newline character, on NT with a combination of newline and carriage return. To get the newline characters converted to this NT-combination you should ftp in ASCII mode.

Jaap.

On Sat, 23 Mar 2002 21:54:25 -0400, "Ryan Gaffuri" <rkg100_at_erols.com> wrote:

>I posted this recently.. but didnt get a full answer. I have an annoying
>problem. When I make my log file and open it in Notepad it opens with a
>bunch of ASCII characters in it. When I open it in Microsoft Word it does
>not have the ASCII characters and is formatted better but not totally lined
>up.
>
>Is there a way to tell SQLLOADER how to output this file? Im deploying this
>far from my work site for a non-technical client. The SQLLOADER will be run
>from a batch process. The client may need to check the log file if there are
>problems... etc... The discard and bad files can be viewed from textpad
>without any problems.
>
>The client will be using a standard Windows NT environment. Is there
>something I can do with the output or is there something simple that I can
>recommend the client do?
>
>
Received on Sun Mar 24 2002 - 04:23:13 CST