TestBench IBM i - File and Report Compare

file and report compare product
  • Unique report compare capability
  • File compare, even over dissimilar tables
  • Partial field support


Compare database and spool files with full selection and error thresholds.


When testing, knowing what has changed since the last test is key to validating the latest software changes. Comparing files and data records is an effective, but time-consuming and laborious, process. When it comes to reports, it’s even harder. Being able to see what is different at a glance, greatly speeds up the testing process.


File Compare

  • Sequence by Arrival Sequence, RRN, PF Key or LF key
  • Specify maximum records to process
  • Specify maximum differences threshold
  • Compare dissimilar files
  • Partial fields comparison
  • Support for dissimilar case, bits and hex

Report Compare

  • Graphically define multiple report sections
  • Spool File capture
  • Set report breaks
  • Set exclusions
  • Optional match by line number
  • Handle Headers and Footers


  • Alternative File Description support
  • Sample data support
  • Multiple User Exits supported

TestBench IBM i Modules

Solutions to cover all  aspects of test data management

Data Extraction

Stop copying the entire live database and hone in on the data you really need. Select or sample data with full referential integrity preserved.

Data Masking & Data Warping

Simply decide which fields need to be protected and use a variety of obfuscation methods to protect your data.

File Effects & Data Rules

Track every insert, update and delete including intervening data states. Create rules so that data failures are flagged to you automatically.

Checkpoints and Rollbacks

Avoid the painful save/restores and stop attempting to explain bad test results based on poor initial data.

File and Report Compare

Comparing outputs is a well proven method to verify your test results but it can be laborious and prone to error.This unique solution can save hours. ​

Testing for Developers

Get under the covers and discover at the database level and beyond what really happens during the course of a test.