SEO

#1 (**permalink**) 02-25-2008, 01:51 PM

Hi! I need to spool the result of a select consult into a file, but not
the consult itself. Is there any way to do this?
My code is:

set termout off
set pagesize 0
set feedback off
set verify off
set linesize 2000
set heading off
set trimspool on

spool c:\data.dat
select 'whatever' from table1;
spool off

So in the data.dat file I get

select 'whatever' from table1;
data
data
data
data

retieved x lines

Is there any way I can get only de "data" lines?
Thanks!

#2 (**permalink**) 02-25-2008, 01:51 PM

"B.-" <beby.akselrad@gmail.com> schreef in bericht
> Hi! I need to spool the result of a select into a file, but not the consult itself. Is there any
> way to do this?
> My code is:
>
> set termout off
> set pagesize 0
> set feedback off
> set verify off
> set linesize 2000
> set heading off
> set trimspool on
> spool c:\data.dat
> select 'whatever' from table1;
> spool off
>
> So in the data.dat file I get
>
> select 'whatever' from table1;
> data
> data
> data
> data
> retieved x lines
>
> Is there any way I can get only de "data" lines?
> Thanks!

set ECHO off

Met vriendelijke groeten

Roelof Schierbeek; DBA

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

spool data into file without the select consult showing?