Spooling query to File give SP2-0308: cannot close spool file [message #5262] |
Thu, 06 February 2003 11:47 |
Jaganmohan
Messages: 3 Registered: February 2003
|
Junior Member |
|
|
Hi,
I executed the script below and I get an error message SP2-0308: cannot close spool file. Can anyone tell me what am I doing wrong.
set pagesize 0
set head off
set linesize 100
set feedback off
set colsep ''
spool FILE1.dat
select cluster_cd,cluster_desc,setid,eff_start_dt,eff_end_dt,active_fg,start_dt,end_date from v_tmp_cluster;
spool off
Thanks for your help.
Jagan
|
|
|
|
|