Re: Spool filename Extension URGENT

From: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Thu, 11 Jan 2001 18:29:45 GMT
Message-ID: <tYm76.74$XP1.4061@nreader1.kpnqwest.net>

spool /tmp/my_file.txt !

<sanjayraj6844_at_my-deja.com> a écrit dans le message : 93hudp$s1r$1_at_nnrp1.deja.com...
> URGENT. Can anybody help
>
> I have created the following script to spool the results to a file. I
> want the extension of the spool filename to be .TXT or something other
> than .LST. Is it possible & How?
>
> set pages 0 linesize 200
> accept territoryid char format 'A10'-
> prompt'Enter territoryid :'
> spool /voyager/data1/NEW/detail_prof_in_&territoryid
> select
> ACCTID,
> Territoryid,
> LastNm,
> FirstNm,
> Addr1,
> Addr2,
> City,
> Stprovcode,
> Zippc
> from prof
> where territoryid='&territoryid'
> order by lastnm
> /
> spool off
>
>
> Thanks
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Jan 11 2001 - 12:29:45 CST