From: Head_Cheese_mmmm <head_cheese_mmmm@my-deja.com>
Newsgroups: comp.databases.oracle.tools
Subject: Help!! How to remove new line Character from spooled output??
Date: Tue, 12 Dec 2000 14:16:54 GMT
Organization: Deja.com - Before you buy.
Lines: 39
Message-ID: <915c0h$cp4$1@nnrp1.deja.com>
NNTP-Posting-Host: 12.26.184.102
X-Article-Creation-Date: Tue Dec 12 14:16:54 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows 95)
X-Http-Proxy: 1.1 x60.deja.com:80 (Squid/1.1.22) for client 12.26.184.102
X-MyDeja-Info: XMYDJUIDhead_cheese_mmmm


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.