I think few months ago there was a lengthy discussion on this and conclusion
was that there is no way to create a view over anything other than *FIRST
member. Let me check the archives... here it is:



2007 System i Fall Technical Conference | Orlando | November 4-7
Celebrating 10-Years of SQL Performance Excellence on IBM i5/OS and OS/400

-----Original Message-----
Subject: ALIAS and VIEW

On V5R3, I can't create a VIEW on an ALIAS over a member. Is this normal
behavior? Anybody think it will ever get fixed? I'm no big fan of members,
but there are lots out there in the real world and ALIAS is the easiest way
to access them.

However, it looks like VIEW won't let me get at them (which also tells me
we're probably getting sent down the CQE execution path every time I look at

If you do a VIEW over a physical and then do an OVRDBF on the physical
before starting SQL, do you get the appropriate member?


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].