Re: Help - SQL*Plus termout off not working

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: 2000/05/25
Message-ID: <392D5B5E.6F3F77CB_at_Unforgettable.com>#1/1

lifter wrote:
>
> 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
#!/bin/ksh

typeset -r User=$1;
typeset -r Pass=$2;
typeset -r Outfile='backup.txt';
typeset -i RecCount=0;
sqlplus -s ${User}/${Pass} <<-sqlEOF >${Outfile}

SET VERIFY OFF
SET ECHO OFF
SET FEEDBACK OFF
SET LINES 10000
set trimout on;
SET PAGES 0
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;
exit success;
sqlEOF
if [[ $? -ne 0 ]];then

    print -u2 "sqlplus operation unsuccessful";     exit 1;
else

    RecCount=$(wc -l <${Outfile};
    print -u1 "${RecCount} records written"; fi
exit 0; Received on Thu May 25 2000 - 00:00:00 CEST