IBM Support

SYSTOOLS.VALIDATE_DATA, SYSTOOLS.VALIDATE_DATA_FILE, and SYSTOOLS.VALIDATE_DATA_LIBRARY

News


Abstract

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.

Content

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

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SS9QQS","label":"IBM i 7.4"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"IBM i 7.4","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
25 October 2020

UID

ibm16174171