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

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