Re: SQL*PLUS spooling and CR/LF

Hi,

    Okay, I just spooled a query to an NT and then FTPd the file, in ASCII mode, over to UNIX and Unix is happy with it (Unix found the line feeds and carriage returns).

    A quick suggestion. Create a file by spooling your query output and then send it via whatever means you plan to use to the other party and see if they can read it. If they can your problem is solved, if not find out what operating system and processor they are using so that we can help you.

regards
Jerry Gitomer

abrusko wrote in message
<0a0133f8.007c49b6_at_usw-ex0106-048.remarq.com>...
>Ken,
>
>I am creating this comma-delimited file to send to an off-
>site service that has told me they require a CR/LF at the
>end of each record.
>
>I don't know what is requiring them to do this, but they
>are requesting the data this way.
>
>Unfortunately I am restricted by the tools that I have
>available and by various other department standards.
>
>I have SQL*PLUS to do my SQL statements, which I am using
>to produce the comma-delimited file that I will send off-
>site. This will be a very simple and effective means of
>producing this file if I can just assure that there is a
>CR/LF at the end of each record. My record will be of
>fixed length (416 characters long) and is I am using 416 on
>the "Set linesize" statement. Shouldn't I be able to view
>this file and shouldn't I be able to "detect" the CR/LF by
>putting the cursor at the end of the line an hitting the
>"arrow" key and being "bounced" down to the next line?
>
>So I'm back to the original question of: How can I ensure
>that there is a CR/LF at the end of each physical line in
>my comma-delimited file?
>
>P.S. Thanks alot for your reply and info!
>
>
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's
Discussion Network *
>The fastest and easiest way to search and participate in
Usenet - Free!
>
Received on Tue Aug 24 1999 - 11:29:50 CDT