IBM Support




There are three data validation services located in the SYSTOOLS schema:
1) SYSTOOLS.VALIDATE_DATA - Validate all rows within a single member.
Special values *FIRST and *LAST can be used as the member name.
2) SYSTOOLS.VALIDATE_DATA_FILE - Validate all rows, within all members, within one file.
3) SYSTOOLS.VALIDATE_DATA_LIBRARY - Validate all rows, within all members, within all files in one library.

Each service will analyze active rows and validate that numeric columns contain valid numeric values.
If an empty result is returned, then no invalid data was encountered.
Any rows returned correspond to a row and column that contains an invalid numerical value.

Note: IBM i Access Client Solutions (ACS) - Run SQL Scripts - Insert from Examples - includes working examples of this service and every other service.


You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Functional Enhancements >  SYSTOOLS.VALIDATE_DATA, SYSTOOLS.VALIDATE_DATA_FILE, and SYSTOOLS.VALIDATE_DATA_LIBRARY  function
validate data services

validate data services

validate data in ACS
For complete detail, visit this IBM Knowledge Center page: VALIDATE_DATA, VALIDATE_DATA_FILE, and VALIDATE_DATA_LIBRARY table functions

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"}]

Document Information

Modified date:
25 October 2020