Hi,
An alias that is created over a physical file member cannot be specified in
an CREATE VIEW statement.
You'll get SQL7030:
Message . . . . : Alias X for table QRPGLESRC in HAUSER not valid for
statement.
Cause . . . . . : The SQL statement cannot be performed on alias X because
the alias refers to a member of table QRPGLESRC in schema HAUSER.
Recovery . . . : Specify a valid table or an alias that does not refer to
a
member. Try the request again.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces+hauser=sss-software.de@xxxxxxxxxxxx
[
mailto:rpg400-l-bounces+hauser=sss-software.de@xxxxxxxxxxxx] Im Auftrag von
Alan Shore
Gesendet: Tuesday, June 26, 2007 18:28
An: RPG programming on the AS400 / iSeries
Betreff: Creating a view
Hi guys
I have been approached with the following problem that has me scratching my
head
We have a file that contains multiple members. A view is required against
ONE of those members. Is this possible, and if so how?
I contemplated creating an ALIAS within qtemp but (unless I'm doing
something wrong) I am stopped from creating a view over this ALIAS I also
thought of creating another temporary file within QTEMP that would have the
data that would be needed and then regenerating the data each and every time
that the "VIEW" would be inquired upon, but this takes quite a while.
Anybody any ideas?
Any help would be MUCH appreciated.
Thanks in advance
Alan Shore
NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill
midrange.com
