Re: Open query file question

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
This happened to me quite often in the past, and, if I recall correctly,
you need to specifiy the Share Open Data Path on the Open and or Override
statement in order to access the data from the open query file.

Good Luck

John C. Boblitz Jr.
Givaudan Dübendorf Ltd.
Informatics
Ueberlandstrasse 138
CH-8600 Duebendorf, Switzerland
Tel: ++41 (0)1 824 22 09
Fax: ++41 (0)1 821 44 78
john_c.boblitz@givaudan.com
http://www.givaudan.com




Lori Crane <lcrane@emedco.com>
Sent by: rpg400-l-admin@midrange.com
07.08.2002 15:39
Please respond to rpg400-l


        To:     rpg400-l@midrange.com
        cc:
        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.