MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » June 2007

RE: Creating a view



fixed

Thanks for your reply Elvis
Yep, you are right. Creating an SQL view for a specific member is NOT
allowed.
However, I've not given up, but I am looking into what has also been
suggested and that is to create a Logical for that member and have the
program do what the view was supposed to do.



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 06/26/2007 12:48:28 PM:

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


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 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