From: David Fitzjarrell <oratune@aol.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Help!! How to remove new line Character from spooled output??
Date: Tue, 12 Dec 2000 14:28:32 GMT
Organization: Deja.com - Before you buy.
Lines: 63
Message-ID: <915cm9$daf$1@nnrp1.deja.com>
References: <915bsk$cfj$1@nnrp1.deja.com>
NNTP-Posting-Host: 64.19.63.135
X-Article-Creation-Date: Tue Dec 12 14:28:32 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
X-Http-Proxy: 1.1 x63.deja.com:80 (Squid/1.1.22) for client 64.19.63.135
X-MyDeja-Info: XMYDJUIDddf_dba


In our last gripping episode Head_Cheese_mmmm <head_cheese_mmmm@my-
deja.com> wrote:
> I am having a hell of a time getting SQL+ to drop the new line
> Character from my spool file. I can't see the Character in vi but it
 is
> there because my script output is 8k but the file size is 9k. The
> script I have written is simple it just calculates the last EOM from
> dual and writes that to a spool file. Several days later a UNIX batch
> file wakes up to read tha date and process the EOM Data, the problem
 is
> that it expects 8k not 9k. Here is the script:
>
> SET TRIMS ON
> SET PAGESIZE 0
> SET EMBEDDED OFF
> SET HEADS OFF
> SET NEWP NONE
> SET HEADING OFF
> SET ECHO OFF
> SET FEEDBACK OFF
> SET LIN 8
> SET SPACE 0
> SET RECSEP OFF
>
> SPOOL $DATA_DIR/sysctl.asc
>   SELECT TO_CHAR(LAST_DAY(ADD_MONTHS(SYSDATE,-1)),'YYYYMMDD') FROM
 DUAL
> /
> SPOOL OFF
>
> EXIT
>
> How do I get rid of the 1k new line Character?????
>
> What I don't understand is the "SET PAGESIZE 0" should "supress all
> headings, pagebreaks,titles,the initial blank line,and other
 formatting
> information ." according to the SQL+ manaual. The O/S is Sun 2.6 and
> the Oracle is 8.01 if it matters.....
>
> TIA
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

You'll not rid yourself of the newline character through any 'magic'
from SQL*Plus.  What I don't understand is that your UNIX script does
not want the inherent newline character.  I have written a number of
UNIX scripts to process batch runs and this has never been a problem.
If you truly having difficulty processing the output from your query
through your UNIX script I will be more than happy to help you sort
that out.  Either post the script or email me a copy at
davidf@bcgsystems.com and I'll help you fix it to accept your current
spool file.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.