IBM i Data Validation, TestBench IBM i Data Validation

Data Validation for IBM i, IBM iSeries, AS/400 Testing

i400Quality-TestBench-File-effects-and-data-rules-image-01
  • Track every database activity
  • Optionally include mid-point states
  • Set validation rules and warnings

Data Validation Overview

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

General

  • 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

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

Data Validation

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

Data Reset

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. ​

Unit Testing

Get under the covers and analyse at a program/module level what happens in the database, APIs, parameters, messages and beyond.

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

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

Data Validation

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

Data Reset

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. ​

Unit Testing

Get under the covers and analyse at a program/module level what happens in the database, APIs, parameters, messages and beyond.