ASA SQL Reference
  System Procedures and Functions
    System and catalog stored procedures

sa_validate system procedure

Function 

Validates all tables in a database.

Syntax 

sa_validate [ tbl_name, ] [ owner_name, ] [ check_type ]

Permissions 

DBA authority required

Side effects 

None

Description 

This procedure is equivalent to calling the VALIDATE TABLE statement for each table in the database.

For information, see VALIDATE TABLE statement.

tbl_name    Validate only the specified table. When NULL (the default), validate all tables.

owner_name    Validate only the tables owned by the specified user. When NULL (the default), validate tables for all users.

check_type    When NULL (the default), each table is checked using a VALIDATE TABLE statement with no additional checks. The check_type value can be one of the following:

• data    Validate tables using WITH DATA CHECK.

• index    Validate tables using WITH INDEX CHECK.

• full    Validate tables using WITH FULL CHECK.

• express    Validate tables using WITH EXPRESS CHECK.

All of the values for the tbl_name, owner_name, and check_type arguments are strings and they must be enclosed in quotes.

The procedure returns a single column, named Messages. If all tables are valid, the column contains No errors detected.

Example 

The following statement validates all of the tables owned by the DBA with an index check:

CALL sa_validate (owner_name = 'DBA', check_type = 'index')