1,025 pts.
 AS400 – DB2
We have CMPPFM command to compare Physical File member. Is there any way to compare logical File members in AS400? I want to compare 1 multi format logical file in 2 Libraries? How to do that?

Software/Hardware used:
ASKED: March 15, 2011  6:41 AM
UPDATED: May 19, 2011  11:53 AM

Answer Wiki:
You can use the same command CMPPFM to compare two logical files.
Last Wiki Answer Submitted:  May 19, 2011  11:53 am  by  Trishaful   70 pts.
All Answer Wiki Contributors:  Trishaful   70 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

I believe your program would work equally well with logical or physical files.

 5,525 pts.

 

CMPPFM requires type PF files. Type LF is not supported.

Especially for a multi-format LF, I don’t see much chance of using a generic tool. It seems reasonable that one could be created, but I wouldn’t expect that anyone ever needed it. (I can’t recall the last time I saw a multi-format LF, though I’m sure they’re still used here and there.)

Since LFs are built over PFs, the PFs might as well be compared. As long as the LF definitions match their selections and formats, the PF data is what’s important.

Tom

 108,055 pts.