RE: Creating a view

[Alan Shore <AlanShore@xxxxxxxx>]

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.