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

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

Compare 2PFs

View previous topic View next topic Go down

Compare 2PFs

Post  maran on Mon Jul 27, 2009 7:16 pm

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

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

Re: Compare 2PFs

Post  sandeepkumar on 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 : 29
Location : chennai

View user profile

Back to top Go down

Re: Compare 2PFs

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

View user profile

Back to top Go down

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

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

View user profile

Back to top Go down

Re: Compare 2PFs

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

View user profile

Back to top Go down

CMPPFM

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

View user profile

Back to top Go down

Re: Compare 2PFs

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