Compare files in AS400
When i compare two files using CMPPFM command, i am getting message as request failed. This is because files were having huge volume of data. It was showing file exceeds 112498 records. Is there any other way to compare files of large volume of data in AS400. Please let me know.

Answer Question   |  June 7, 2011  6:42 PM
AS/400 command functions, AS/400 DB2, AS/400 File Sharing, CMPPFM

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?

Answer Question   |  May 19, 2011  6:41 AM
AS/400 DB2, AS/400 Library, CMPPFM, Logical Files

CMPPFM, Space offset error.
Hello, I’m using the IBM CMPPFM utility for a file comparision process. I monitor for msg SPC5010 (file is too big ), if this occurs I submit an SQL EXCEPT to compare the files. This has been working fine until recently, now I’m getting the following error on one file, Space offset X’00FFF026′ or X’0000000000000000′ [...]

Answer Question   |  February 26, 2009  7:51 PM
CMPPFM, SQL Exception, SQL/400