Re: How to alias a member with a dot in its name?

[Javier Sanchez <javiersanchezbarquero@xxxxxxxxx>]

Not sure about your question.  The CREATE ALIAS statement is much like
doing an OVRDBF to the member, using, say, QCMDEXC before you start making
use of that member:
OVRDBF FILE(MYFILE) MBR(MYMBR)

So you would just like:

SELECT * FROM MYFILE

would be getting all rows of MYMBR.  But you cannot use a dot to specify
the member in SELECT FROM to point to MYMBR.


El jue, 10 nov 2022 a las 13:35, John Yeung (<gallium.arsenide@xxxxxxxxx>)
escribió:

> Normally, you can do
>
>   CREATE ALIAS MYALIAS FOR MYLIB.MYFILE(MYMBR)
>
> and then you can query MYMBR via MYALIAS. But what if you are trying
> to work with MYFILE(MY.MBR)?
>
> John Y.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com