Help - SQL*Plus termout off not working

From: lifter <pummellerNOpuSPAM_at_netscape.net.invalid>
Date: 2000/05/25
Message-ID: <32d0cd4f.39007862_at_usw-ex0108-062.remarq.com>#1/1

[Quoted] [Quoted] I need to spool query output to a flat file, and I want to suppress the screen output. I am entering Sql*Plus through a Unix shell script and setting TERMOUT OFF. However, the output file is still scrolling to the screen. Is there anything else I can do to stop it?

---

sqlplus -s $USER/$PASS << EOF
SET TERMOUT OFF
SET HEAD OFF
SET VERIFY OFF
SET ECHO OFF
SET FEEDBACK OFF
SET LINES 10000
SET PAGES 0
SET TRIMSPOOL ON SPOOL ${DIR}/backup.txt

SELECT

   dd.typ||chr(124)||
   dd.inv||chr(124)||
   dd.rule||chr(124)||

   TRIM(TRAILING FROM dd.code)||chr(124)||

   dd.orig_num||chr(124)||
   dd.cdt||chr(124)||
   dd.ctime

FROM del_detail dd;
SPOOL OFF;
EOF

---

Thanks!

• Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

Received on Thu May 25 2000 - 00:00:00 CEST