Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

OPNQRYF and OVRDBF

156 views
Skip to first unread message

Tomasz A. Skorża

unread,
May 21, 2003, 6:59:26 AM5/21/03
to
Hi AS-guys

I have a little problem with these two CL commands.
Situation is following:
In CLP-A I have code:

OVRDBF FILE(F4211LA) OVRSCOPE(*CALLLVL) SHARE(*YES)
OPNSCOPE(*ACTGRPDFN)
/*
CALL PGM(PH98315) PARM(&PSPID &PSVERS &PSFIL1 +
&PSMSGQ)

PH98315 - it is my version of P98315, it is JDE program to create query on
file from PSFIL1, in this case it is F4211LA (logical).

Then I call RPG-A with declaration:

FF4211LA UF E K DISK

and in F4211LA I have acces only to record with selection from query. No
problem.

Then RPG-A call CLP-B with code:
OVRDBF FILE(F4211I) TOFILE(F4211LA)

and then CLP-B call RPG-B where F4211I is declared:
FF4211I UF E K DISK

But when I try read any record from file F4211I, program can't find any
records.

Why?
Have you any idea?
What I wrote wrong?

Regards

Tomasz Skorza


Tomasz A. Skorża

unread,
May 21, 2003, 7:30:42 AM5/21/03
to
I found one way;
CPYFRMQRYF to other file.

Regards

Tomasz Skorza

Użytkownik "Tomasz A. Skorża" <tom...@poczta.onet.pl> napisał w wiadomości
news:bafm1l$n75$1...@news.onet.pl...

Tomasz A. Skorża

unread,
May 21, 2003, 7:38:39 AM5/21/03
to
Sorry, this is answer for second question :-)

Użytkownik "Tomasz A. Skorża" <tom...@poczta.onet.pl> napisał w wiadomości

news:bafns6$s0o$1...@news.onet.pl...

Tim M

unread,
May 21, 2003, 8:06:07 AM5/21/03
to
You must specify the same override paramaeters on F4211I that you did on
F4211LA

"Tomasz A. Skorża" <tom...@poczta.onet.pl> wrote in message
news:bafm1l$n75$1...@news.onet.pl...

Tomasz A. Skorża

unread,
May 21, 2003, 8:24:47 AM5/21/03
to
OK, but if OVRSCOPE(*CALLLVL) and OPNSCOPE(*ACTGRPDFN) is right?

Regards

Tomasz Skorza

Użytkownik "Tim M" <scot...@cox.net.xyz> napisał w wiadomości
news:PYJya.190299$vU3.1...@news1.central.cox.net...

Mercury

unread,
May 21, 2003, 8:23:38 AM5/21/03
to
This has likely something to do with the OVRSCOPE(*CALLLVL) parameter.
I think you should add this OVRSCOPE on the second override i.e. OVRDBF FILE(F4211I) TOFILE(F4211LA) OVRSCOPE(*CALLLVL)
and test again. Am I wrong ?
See also (long url)
http://iseriesnetwork.com/resources/artarchive/index.cfm?fuseaction=viewarticle&CO_ContentID=10447&channel=art&PageView=Search
to get more explanations
hth
Mercury


"Tomasz A. Skorża" <tom...@poczta.onet.pl> a écrit dans le message de news: bafm1l$n75$1...@news.onet.pl...

Steve Landess

unread,
May 21, 2003, 8:52:27 AM5/21/03
to
Tomasz -
If you are working with JDE, you need to learn more about the way JDE does
things. Otherwise you're going to write a lot of code that is unnecessary.
The CD-ROM documentation has a section with technical documentation
(Technical Foundation) about DreamWriter that explains the concepts.

You need to look at what JDE does to reposition the file _after_ it has been
processed in an RPG program. You call J81OQ to reposition the file pointer
in order to reprocess the file. Look at J42520 for an example of how to
call this program.

Then your program RPG-B will have successfully be able process the
OPNQRYF-created file _again_.

HTH
Steve Landess
Austin, Texas
(512) 423-0935


"Tomasz A. Skorża" <tom...@poczta.onet.pl> wrote in message
news:bafm1l$n75$1...@news.onet.pl...

Tomasz A. Skorża

unread,
May 21, 2003, 9:11:52 AM5/21/03
to
Hi Steve

Thank you for your help.

Regards

Użytkownik "Steve Landess" <steve_...@hotmail.com> napisał w wiadomości
news:fEKya.1824$A17.3...@twister.austin.rr.com...

0 new messages