title: remove sql from spool file
body: <p>I have a SQL script that I am running in a shell.  The problem is I am unable to get rid of the SQL in the spool file.</p>
  
  <p><strong>SQL file :</strong></p>
  
  <pre><code>set termout off
  set echo off
  set pagesize 0
  set linesize 18
  set heading off
  set feedback off
  set tab off
  set space 0
  set verify off
  set timing off
  spool abc.dat
  select
  RPAD(abc,10,' '),
   LPAD(ssss,4,'0'),
  LPAD(xxx,4,'0')
  from  whtevertable where rownum &lt; 10;
  spool off
  exit
  EOF
  </code></pre>
  
  <p><strong>abc.ksh</strong></p>
  
  <pre><code>#!/bin/ksh
  sqlplus /
   @datafile.sql
  </code></pre>
  
  <p>Am I calling the SQL script correctly?</p>