RE: Open query file question

[Sridhar_Madduri <Sridhar_Madduri@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 ]
try giving ..

OVRDBF     FILE(ORD0100T) TOFILE(MKTLIB/ORD0100T)  SHARE(*YES)

appreciate if you let me know the result....


> -----Original Message-----
> From: Lori Crane [SMTP:lcrane@emedco.com]
> Sent: Wednesday, August 07, 2002 7:09 PM
> 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.
**************************************************************************
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**************************************************************************