Log file avoid dumping sql query data in it.. c shell

Question

I have sql script "example.sql":

SPOOL &1
Select '<.TR>'||'<.TD align="left">'||column_name||'<./TD>'||'<.TR>' from table1;
spool off

which dumps it contents to cshell script "getdata.csh" this is how i get data from sql script to csh script

sqlplus $ORA_UID/$ORA_PSWD @${SQL}example.sql ${DATA}${ext}

My problem is when I run my job to do this it dumbs all data extracted from sql query in log file too.. How can I avoid dumbing data into log files. What do I have to do in this code to do so? thank you

Mat · Accepted Answer · 2011-03-30 18:42:37Z

2

Look here for information about your issue: sqlplus spool

Essentially, you will need to add these two settings:

set echo off
set termout off

answered Mar 30, 2011 at 18:42

Mat

208k41 gold badges407 silver badges423 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

jack Over a year ago

if i do termout off can i retrive output in ${DATA}${ext} or it will completely stop dumping query output

Mat Over a year ago

please read that link, it answers the question directly, with links to explain both of these.

Collectives™ on Stack Overflow

Log file avoid dumping sql query data in it.. c shell

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related