I don't think it can be done (creating SQL view for a specific member).my
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.
Celebrating 10-Years of SQL Performance Excellence
Subject: Creating a view
I have been approached with the following problem that has me scratching
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
every time that the "VIEW" would be inquired upon, but this takes quite alist
Anybody any ideas?
Any help would be MUCH appreciated.
Thanks in advance
(631) 244-2000 ext. 5019
"If you're going through Hell, keep going" - Winston Churchill
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
This mailing list archive is Copyright 1997-2013 by MIDRANGE dot 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 here. If you have questions about this, please contact