RE: OVRDBF and SQL

Rob,

I was looking at that (saw a reference in the archives, and looked it up
in Paul Conte's excellent tome).

I can see how it works for an multi-member file, but I'm not sure how to
use it in my case, since I am passing in a completely different file
name as a parameter.  The SQL Reference tells me the alias name can't be
the name of an existing file, and the compiler won't let me use a
variable as the file name, eg:

Create Alias MKPHSW
For :P#File

So how do I get SQL output normally directed to MKPHSW to output to the
value found in P#File instead ? 

Thanks

Greg

>-----Original Message-----
>From: midrange-l-bounces@xxxxxxxxxxxx 
>[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
>Sent: Tuesday, October 04, 2005 5:22 PM
>To: Midrange Systems Technical Discussion
>Subject: Re: OVRDBF and SQL
>
>
>See also
>CREATE ALIAS
>
>Rob Berendt
>-- 
>Group Dekko Services, LLC
>Dept 01.073
>PO Box 2000
>Dock 108
>6928N 400E
>Kendallville, IN 46755
>http://www.dekko.com
>