|
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 -- "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." Benjamin Franklin Joel Cochran <jrc@xxxxxxxxxx> Sent by: rpg400-l-bounces@xxxxxxxxxxxx 11/21/2003 10:38 AM Please respond to RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx> To RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx> cc Subject Re: SQL Select from a record Just to share an experience, I've never gotten an ALIAS to work, and it's not for a lack of trying. I try to create an alias like so: create alias CGILIB/FRNMAST for cgilib/cafpmast(FRN) I get a message: "FRNMAST in CGILIB type *FILE already exists." (which it does not) But when I try to run a statement against the alias: select count(*) from cgilib/frnmast where MYRSLD = 1903 I get a message: "CAFPMAST in CGILIB type *FILE not found." (This is the actual physical and definitely DOES exist) As much as I dislike them, overrides always work. Joel http://www.rpgnext.com On Fri, 2003-11-21 at 16:29, Wills, Mike N. (TC) wrote: > I am accessing a file with multiple members. I need to be able to use SQL to > get at a record other than the default record. How do I do this in SQL? > > Mike Wills > Lawson Programmer/Administrator > Taylor Development > Email: mnwills@xxxxxxxxxxxxxx > Direct Line: (507) 625-3187 > > CONFIDENTIAL INFORMATION > > NOT TO BE COPIED WITHOUT AUTHORIZATION > > The information contained in this electronic mail transmission may contain > privileged communications and/or confidential information intended only for > the use of the named recipient(s). If the reader of this information is not > the named recipient(s) or you receive this transmission in error, please: > (1) immediately notify us by return electronic transmission at > mnwills@xxxxxxxxxxxxxx; and (2) permanently delete this message from your > computer and all servers and other stored devices. > > _______________________________________________ > 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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.