SQL operations (SELECT, UPDATE, etc.) do pay attention to OVRDBF's that may
be in effect. Perhaps an OVEDBF specifying the MBR name before running your
SQL?
Bill
-----Original Message-----
From: Alan Shore [
mailto:AlanShore@xxxxxxxx]
Sent: Tuesday, June 26, 2007 12:29 PM
To: Midrange Systems Technical Discussion
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
