Re: SQL-Plus spooling problem

change your script to this:

set echo off
set head off
set pagesize 0
set linesize 4000
set feedback off
set verify off

SELECT 'update CONVINFO set intTotTabRecords = (select COUNT(*) FROM '||bestandnaam||') where bestandnaam='''|| bestandnaam||CHR(39)||';'from  rubriek GROUP by bestandnaam

spool c:\temp\convcount.sl

/

spool off

This will only put the results of the query into your spool file.

HTH In article <75lj39$pq1$1_at_thor.wirehub.nl>,   "John van Kaam" <nospamjohn.v.kaam_at_adp.nl> wrote:
> Hi,
>
> I used to use a sql script like:
>
> set echo off
> set hea off
> set pagesize 0
> set linesize 4000
> set feedback off
> set verify off
>
> spool c:\temp\convcount.sql;
> SELECT 'update CONVINFO set intTotTabRecords = (select COUNT(*) FROM
> '||bestandnaam||') where bestandnaam='''|| bestandnaam||CHR(39)||';'from
> rubriek GROUP by bestandnaam;
> spool off;
>
> edit c:\temp\convcount.sql
>
> Now there use to come an output file with just the results of the select
> statement. Now also the SQL> prompt comes along and the initial
> SQL-statement. This was never so. We still have machines that work without
> this problem. What is wrong?
> I could set the sqlprompt like:
>
> set sqlprompt ""
>
> but then I still get the inital SQL-statement and I only used to get the
> output!
>
> Who can help.
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 22 1998 - 00:00:00 CST