TestBench IBM i - File Effects and Data Rules

Product: File effects and data rules
  • Track every database activity
  • Optionally include mid-point states
  • Set validation rules and warnings


Track every database activity. Create rules so that data failures are flagged to you automatically

Data is a core part of any IBM i application and looking at what happens to that data is a core part of testing. You may well be familiar with SQL statements that help you look at the end result of a test. What you really need to know is what stages a changed piece of data went through, where an error was introduced and by which process.

File Effects

  • Track every insert, update and delete operation
  • Optionally track multiple activity on a single record
  • View Before and After record images
  • Search by values
  • Track all activity for a Relative Record Number (RRN)
  • Track all activity for a selected field

Data Rules

  • Check for data presence and changed values
  • Check for specific values
  • 20 validation operators
  • Standard field types supported
  • Check values across file with SUM and EXISTS


  • Alternative File Description support
  • Sample data support

TestBench IBM i Modules

Solutions to cover every aspect 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.