Alias not working in STRSQL

[Joel Cochran <jrc@xxxxxxxxxx>]

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


On Fri, 2003-11-21 at 22:01, Haas, Matt wrote:
> Joel,
> 
> I just tried this on one of our V5R1 boxes and it worked perfectly. It's on 
> DB group 10 (3 behind, you can see where you're at by looking at data area 
> SF99501) and the cume is from around that same time (October 2003). If you 
> haven't been keeping up on group PTF's, there may be some important fixes 
> you're missing. I don't think that everything in a group always ends up in 
> the cume's and I know there's stuff that isn't in either.
> 
> Matt
> 
> -----Original Message-----
> From: Joel Cochran [mailto:jrc@xxxxxxxxxx]
> Sent: Friday, November 21, 2003 11:39 AM
> To: RPG programming on the AS400 / iSeries
> Subject: Re: SQL Select from a record
> 
> 
> On Fri, 2003-11-21 at 21:06, rob@xxxxxxxxx wrote:
> > Works fine for me:
> > CREATE ALIAS ROB/JOELTEST FOR ROB/AAAKEY (DBL2)
> > Alias JOELTEST created in ROB. 
> > select * from rob/joeltest
> > 
> > What version of OS and cume of that are you on?  I did find a ptf for V4R4 
> > that mentions SQL0601.  Is that the message you are seeing?
> > 
> > Rob Berendt
> 
> Thanks Rob,
> 
> Yes, it is SQL0601.  I'm at V5R1, TL03007.
> 
> Joel
> http://www.rpgnext.com
> 
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
> 
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.