Re: Viewing Data from an OPNQRYFL

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

The result of OPNQRYF is NOT a file. It is an open data path - an 
access plan. It is all virtual. UPDDTA is working against the 
original file - it can't work against an ODP.

So to do what you want, follow the other poster's advice and use 
CPYFRMQRYF - but you don't do an override when using that, generally. 
Others can speak to this more - the override is only to get the RPG 
programs to use the ODP created by OPNQRYF.

Anyway, think about moving to embedded SQL - much more power there.

HTH
Vern

At 06:40 AM 5/18/2007, you wrote:

> Is there a way to view the contents of a file that is overriden and 
> has records selected via OPNQRYFL during a STRISDB session?  If you 
> do F21 during the debugging session and do an UPDDTA command, you 
> get the full file.  I'd like to see the contents after the records 
> are selected.  Thanks!
>
> _________________________________________________________________
> Make every IM count. Download Messenger and join the i'm Initiative 
> now. It's free. http://im.live.com/messenger/im/home/?source=TAGHM_MAY07
>
>
>
> --
> 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.