Re: Alias not working in STRSQL

[G Armour <garmour400r@xxxxxxxxx>]

We had this same problem a few months ago.  Tried to delete an alias, got an 
error
saying it didn't exist.  So, tried to create the alias, got an error saying it
already existed.  

I do remember that we had to download a few PTF's that were not in the cume or 
the
DB group.  My notes show SI09517 & SI10134 were PTFs that we needed to download
individually.  (I searched the APARs & PTFs on IBM's site for CPF32A6.)

Do a DSPLOG on CPF32A6.  If you are getting this, you need to do a RCLSTG
SELECT(*DBXREF).

HTH, GA

--- Joel Cochran <jrc@xxxxxxxxxx> wrote:
> I know this has been a while, but I'm finally getting back to it.  I've
> applied group ptfs for SF99501 through the current level 13 and am up to
> date on Cum PTFs.  However I'm still having the same problem:
> 
> When I try to create an SQL Alias for a Member in a physical file (using
> STRSQL), I receive a message that the Alias name already exists.  When I
> try to do a "Select ..." on the Alias name, I get a message saying that
> the original Physical file cannot be found.
> 
>     > create alias cgilib/frnmast for cgilib/cafpmast (FRN)
>       FRNMAST in CGILIB type *FILE already exists.
>     > select * from cgilib/frnmast where moccup > 30
>       CAFPMAST in CGILIB type *FILE not found.
> 
> I can get around the problem by overriding the file first, then doing my
> SQL work, but it really irks me that this doesn't work as advertised.
> 
> If anyone has any other input it would be most appreciated,
> 
> Joel
> http://www.rpgnext.com


__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html