Hi all,
I am running a query which will pull approx 35,000 rows of record. The script is very simple as shown below:
******************************
set echo off
set feedback off
set pages 0
set heading off
set flush off
set trimspool on
SELECT SKU, MANUFACTURERSKU,RETAILSKU,ALTSKU FROM SKU;
SPOOL C:\SKU_TBL\REPORT.TXT;
SPOOL OFF;
exit
*******************************
I could see every thing on the screen but the spool file contains zero data/record... simply a blank file. I already tried to change the file extension to .doc/.xls/.log but it is still the same problem.
Can someone help me with this? Am I missing some thing????
Thanks....
Hugh
I am running a query which will pull approx 35,000 rows of record. The script is very simple as shown below:
******************************
set echo off
set feedback off
set pages 0
set heading off
set flush off
set trimspool on
SELECT SKU, MANUFACTURERSKU,RETAILSKU,ALTSKU FROM SKU;
SPOOL C:\SKU_TBL\REPORT.TXT;
SPOOL OFF;
exit
*******************************
I could see every thing on the screen but the spool file contains zero data/record... simply a blank file. I already tried to change the file extension to .doc/.xls/.log but it is still the same problem.
Can someone help me with this? Am I missing some thing????
Thanks....
Hugh