RE: Open query file question

["Hillier, Martin" <Martin.Hillier@xxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Hi Lori

Use SHARE(*YES) on the OVRDBF command, and look at the OPNSCOPE keyword on
the OPNQRYF command - the activation group of the CLLE and the called RPG
(LE?) may need to be considered.

Cheers,
        Martin

> -----Original Message-----
> From: Lori Crane [SMTP:lcrane@emedco.com]
> Sent: 07 August 2002 14:39
> To:   rpg400-l@midrange.com
> Subject:      Open query file question
>
> Hello,
>
> I have an open query file question.  I have created a CLLE pgm having the
> following code(very simple select).  The open query seems to work because
> I
> also created a copy from query file and the correct data resides in the
> file.  The problem seems to be the pgm does not attach itself to the open
> query file.  This is running on V5R1.  Does anyone have any suggestions?
>
>  OVRDBF     FILE(ORD0100T) TOFILE(MKTLIB/ORD0100T)
>
>  OPNQRYF    FILE((MKTLIB/ORD0100T)) OPTION(*ALL) +
>               QRYSLT('OGITEM = ''EM75-SC''') +
>               KEYFLD((OGSTOK) (OGCORD) (OGOLIN)) +
>               SEQONLY(*NO) OPNSCOPE(*JOB)
>
> CALL       PGM(MKTLIB/OB0500)
>
> Lori
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.