PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

Join the forum, it's quick and easy

PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).
PMS Information Systems
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Ovrdbf with Opnqryf

3 posters

Go down

Ovrdbf with Opnqryf Empty Ovrdbf with Opnqryf

Post  muthuraman Tue Oct 27, 2009 1:35 am

Can we use OVRDBF command without using of OPNQRYF ? Or can we use OPNQRYF command without using of OVRDBF command ?


Regards,
Muthuraman.

muthuraman

Posts : 42
Join date : 2009-08-28

Back to top Go down

Ovrdbf with Opnqryf Empty Re: Ovrdbf with Opnqryf

Post  amarasuresh Tue Dec 14, 2010 7:03 pm

When we are using OPNQRYF command at that time Before OPNQRYF CMD we must and should use the OVRDBF command.But when we use the OVRDBF command alone itself no problem that means

OVRDBF FILE(*LIB/FILE)
RCVF

IT'S WORK NO PROBLEM.BUT WHEN WE SPECIFY

OPNQRYF QRTSLT(EMPCDE *GT 10)

ALONE IS NOT POSSIBLE IT SHOWS ERROR AT THAT TIME BEFORE OPNQRY FILE WE CAN USE THE OVRDBF CMD THAT'S IMPORTANT...

OVRDBF FILE(*LIB/FILE)
OPNQRYF QRTSLT(EMPCDE *GT 10)
RCVF


amarasuresh

Posts : 13
Join date : 2010-06-18

Back to top Go down

Ovrdbf with Opnqryf Empty Re: Ovrdbf with Opnqryf

Post  soundhar Mon Jun 03, 2013 6:21 pm

OVRDBF is only for Sharing ODP throughout the calling programs.
we can use OPNQRYF without OVRDBF but its of no use.
For ex
If we use OVRDBF + OPNQRYF in our program, then if we use RCVF command will read only the selected records from OPNQRYF
If we use OPNQRYF alone, then RCVF will read the file fully and not the selected records from OPNQRYF
Finally if we want to use the selected records from OPNQRYF in RPG program after CL, then we need to use OVRDBF + OPNQRYF + CPYFRMQRYF

soundhar

Posts : 67
Join date : 2010-07-14
Location : Vridhachalam/chennai

Back to top Go down

Ovrdbf with Opnqryf Empty Re: Ovrdbf with Opnqryf

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum