Re: spooling SQL*PLUS to interactively concatonated filename

this script will rename the file list.lst to (sysdate).lst this should pretty much help you.

rem
rem this will rename you file
rem

set feedback off
set heading off
set pagesize 999
set verify off
spool dummy.sql

select 'host rename list.lst '||to_char(sysdate,'YYMMDD')||'.lst'

        from dual;
spool off

set feedback on
set heading on
set pagesize 21
set verify on

_at_dummy.sql

good luck
In article <01be4a2c$a4d08ce0$d64cc782_at_Gorden.bis.bnl.gov>,   "Pat Gorden-Ozgul" <gorden_at_xs.bis.bnl.gov> wrote:
> We run spool files in batch mode and would like to place the actual date in
> the stored spool filename itself for auditing purposes.
>
> If you know how, pls email me: gorden_at_bnl.gov. Thx.
>
>

Frank Delisle
Consultant, Eds Québec
e-mail: francois.delisle_at_prosig.qc.ca "Un problème sans solution n'est pas un problème"

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Jan 28 1999 - 14:47:54 CET