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.

Compare 2PFs

4 posters

Go down

Compare 2PFs Empty Compare 2PFs

Post  maran Mon Jul 27, 2009 7:16 pm

How can we check both files (PF) are having same set of data?
maran
maran
Admin

Posts : 442
Join date : 2009-07-24

https://pmsinformationsystem.forumotion.net

Back to top Go down

Compare 2PFs Empty Re: Compare 2PFs

Post  sandeepkumar Thu Aug 27, 2009 2:49 pm

by doing run quiry on that two physical files we can check whether they contain same data........

sandeepkumar

Posts : 4
Join date : 2009-08-26
Age : 36
Location : chennai

Back to top Go down

Compare 2PFs Empty Re: Compare 2PFs

Post  razuk_r Fri Aug 28, 2009 1:48 pm

Hi Sandeep,

doing run quiry on that two physical files

If we have thousands of records, is it fair to compare two PF from runqry?

razuk_r

Posts : 65
Join date : 2009-07-31
Location : Chennai

Back to top Go down

Compare 2PFs Empty How can we check both files (PF) are having same set of data?

Post  muthuraman Fri Aug 28, 2009 8:20 pm

Using join logical files with equal keyword we can achive this.

Regards,

Muthuraman.

muthuraman

Posts : 42
Join date : 2009-08-28

Back to top Go down

Compare 2PFs Empty Re: Compare 2PFs

Post  razuk_r Fri Aug 28, 2009 8:51 pm

Hi, Muthu,

Using join logical files with equal keyword

I am not understand what you are syaying. I think you may misunderstand the question.

We have to check both files (PF) are having same set of data or not. I am sure using JLF we don't acheive this.

razuk_r

Posts : 65
Join date : 2009-07-31
Location : Chennai

Back to top Go down

Compare 2PFs Empty CMPPFM

Post  razuk_r Tue Sep 01, 2009 4:19 am

By doing compare physical file member CMPPFM we can check both files are same set of data or not.

razuk_r

Posts : 65
Join date : 2009-07-31
Location : Chennai

Back to top Go down

Compare 2PFs Empty Re: Compare 2PFs

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top


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