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

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

Ovrdbf with Opnqryf

View previous topic View next topic Go down

Ovrdbf with Opnqryf

Post  muthuraman on 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

View user profile

Back to top Go down

Re: Ovrdbf with Opnqryf

Post  amarasuresh on 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

View user profile

Back to top Go down

Re: Ovrdbf with Opnqryf

Post  soundhar on 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

View user profile

Back to top Go down

Re: Ovrdbf with Opnqryf

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


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