Re: spool question
From: Tony Gayda <tony.gayda_at_peachtreecityga.removethis.ncr.com>
Date: Tue, 02 Jun 1998 16:53:12 -0400
Message-ID: <01bd8e67$e3c42460$291e5599_at_gapeachgaydat.Peachtreecityga.ncr.com>
Date: Tue, 02 Jun 1998 16:53:12 -0400
Message-ID: <01bd8e67$e3c42460$291e5599_at_gapeachgaydat.Peachtreecityga.ncr.com>
Dennis-
You need to "SET TERM OFF" in order to prevent output from going to your screen. This only works if you are running your SELECT statement from a ".sql" script and not directly entering it at the "SQL>" prompt.
-- To reply remove the "removethis." from my email address. Dennis M. Hancy <dw724_at_cleveland.Freenet.Edu> wrote in article <6l0t25$ri9$1_at_pale-rider.INS.CWRU.Edu>...Received on Tue Jun 02 1998 - 22:53:12 CEST
>
> In SQL, I am running a Select statement that produces quite a bit of
> output. I decided to spool the output to a file, yet when I run the
> Select statement, the output still goes to my screen (it goes to the file
> as well which is a good thing). What command can I use to prevent the
> output from going to the screen? I tried "set feedback off" and
> "set echo off" but neither one does the trick.
>
> If you have any ideas on this, please email me. Thanks in advance.
>
>
> Dennis Hancy
> Eaton Corporation
> Cleveland, OH
>