Re: Only select data in spool-file

From: FC <flavio_at_tin.it>
Date: Tue, 10 Dec 2002 22:24:38 GMT
Message-ID: <GQtJ9.2898$ab2.89447@news1.tin.it>

Besides that, note also that if the last line of sql script being executed does not contain a newline character, you'll get a message like: "Input truncated to <n> characters" (or an equivalent translation for some other language),
where <n> depends on the total number of characters that make up the last line.

This seems to happen regardless of the options specified with SET. It can be very annoying if you are going to process the file automatically later on.

Bye,
Flavio

"thazanm" <member_at_dbforums.com> wrote in message news:2264529.1039553377_at_dbforums.com...
>
> SET FEED OFF
> SET ECHO OFF
> SET VERIFY OFF
> SET TERM OFF
>
>
> SPOOL FILE.LOG
>
>
> SELECT ........ FROM .......
>
> SPOOL OFF
> SET FEED ON
> SET ECHO ON
> SET VERIFY ON
> SET TERM ON
>
> I am getting only the data. This may help you.
> Thazul
>
> --
> Posted via http://dbforums.com
Received on Tue Dec 10 2002 - 16:24:38 CST