Re: Using Substitution Variables Dynamically in File Names

sfitzgerald02_at_gmail.com wrote:
> I'm looking to use a substitution variable in a file name. Here is
> what I have so far.
>
> column sn new_value company_name noprint
> select scompanyname into :company_name from tblcompany where
> ncompanyid = :companyid
> spool /home/utils/companyReport/&company_name.&file_time..txt
>
> prompt -- &company_name --;
>
> The variable &company_name doesn't appear to be working. Any help
> would be appreciated.
>
> Thanks.
>
> Steve
>

Define not working.

col sn noprint new_value company_name

select scompanyname sn from tblcompany where ncompanyid = :companyid

No idea where you get :companyid from - shouldn't it be &companyid?!?

And use double ampersands (&&) in stead of single.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...