Re: creating a view

Thanks for your reply Peter
With ALL the testing on this that I've done based upon the suggestions that
I have received (which as always is MUCH appreciated) I'm NOT 100% sure of
my following reply, but I am 95% sure.
Anyway, to answer your question.
The view that gets created only has ONE member, no matter what I tried with
the OVRDBF, and I think (only 75% sure on this) but the view gets created
from the *FIRST member (whatever that is)



Alan Shore

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

rpg400-l-bounces@xxxxxxxxxxxx wrote on 06/28/2007 03:13:25 PM:

Hi Alan,

Having run into the same problem myself, I read this thread with great
interest. Then I tried:

STRSQL

CREATE VIEW mylib/sourcev AS SELECT * FROM mylib/QRPGLESRC

Exited SQL

OVRDBF FILE(SOURCEV) TOFILE(mylib/QRPGLESRC) MBR(NOT1ST)

STRSQL

SELECT * FROM SOURCEV

this showed the contents of member NOT1ST.

SELECT * FROM mylib/QRPGLESRC

this showed the contents of the first member

Then I tried

OVRDBF FILE(SOURCEV) TOFILE(mylib/QRPGLESRC) MBR(*ALL)

which didn't work -- diagnostic msg SQL0204 "*ALL in *N type *MEM
not found. "

Anyway, is it possible you could simply

OVRDBF FILE(someview) TOFILE(somefile) MBR(somembr)
CALL somepgm

where "somepgm" opens "someview" and processes it?

*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /


--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.