I don't think it can be done (creating SQL view for a specific member).
I'd create a permanent ALIAS for that member and put the SQL logic in a
SELECT statement inside embedded SQL.
Then modularize that procedure so it's called by other parts of the
application that need to access that specific result set.
Other possibility is DECLARE GLOBAL TEMPORARY TABLE.... but I don't think
that'll perform as well as the previous suggestion.
HTH, Elvis
Celebrating 10-Years of SQL Performance Excellence
http://centerfieldtechnology.com/training.asp
-----Original Message-----
Subject: 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
