RE: creating a view

Thanks for your reply Eric, but sad to say when I run
SELECT * FROM INPOPAXS
after the OVRDBF, i get the raw data from the file (RMSFILES#/INPOP300)
MBR(M026) and not from the view.



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/29/2007 10:03:30 AM:

Lets try:

CREATE VIEW AXSLIB/INPOPAXS (HOUSE, PRDNO, DIFF) AS SELECT HOUSE,
PRDNO, SUM(QUANO - QUANR) FROM RMSFILES#/INPOP300 GROUP BY HOUSE,
PRDNO

OVRDBF FILE(INPOP300) TOFILE(RMSFILES#/INPOP300) MBR(M026)
(The override affects the open of file INPOP300, which is the file
that gets opened when the view is activated...)

and run
SELECT * FROM INPOPAXS

Eric

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Alan Shore
Sent: Friday, June 29, 2007 7:23 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: creating a view


Thanks Peter
Dope slaps on me
My create view was
CREATE VIEW AXSLIB/INPOPAXS (HOUSE, PRDNO, DIFF) AS SELECT HOUSE,
PRDNO, SUM(QUANO - QUANR) FROM RMSFILES#/INPOP300 GROUP BY HOUSE,
PRDNO

However when I change my OVRDBF to
OVRDBF FILE(INPOPAXS) TOFILE(RMSFILES#/INPOP300) MBR(M026)
(The correct way)
and run
SELECT * FROM INPOPAXS
I still get the data from the *FIRST member



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 05:28:11 PM:

Isn't that TOFILE parm supposed to be TOFILE(RMSFILES#/INPOP300)?

What does your CREATE VIEW statement look like?

Alan Shore wrote:

Well Charles - I was right, I had done something wrong
I revisited your example and realized the original OVRDBF was in fact

WRONG

so I submitted
OVRDBF FILE(INPOPAXS) TOFILE(INPOP300/RMSFILES#)
MBR(M026)

where INPOPAXS is the view that I created
I then tried DBU and received a divide by 0 error
Within STRSQL I tried
select * from inpopaxs
and received the following error

INPOPAXS in INPOP300 type *FILE not found

Anyone any thoughts?

--
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.

--
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.




--
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.