Re: Spool filename Extension URGENT

sanjayraj6844_at_my-deja.com wrote:

> 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
>

You can name a spool file anything you want.

For example:

SQL> spool d:\thisisthespoolfilenameIwant2use.txt.asc.sql

works just fine.

Daniel a. Morgan Received on Fri Jan 12 2001 - 01:16:03 CST