Re: Alias not working in STRSQL

Can you run this under STRDBG and post the joblog?

I like SQL as much as the next guy.  But vendors beware.  If there is a 
chance that the file you are going to create an alias on is in a library 
where the user has only read access then perhaps you'd be better served 
using an override instead.  I know of one vendor that had this happen. 
(Hopefully the vendor won't just adopt authority to get around it.  I 
suspect this vendor won't adopt authority.)

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





Joel Cochran <jrc@xxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
02/17/2004 03:29 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Fax to

Subject
Alias not working in STRSQL






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.

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