Check objects

Previous Next

Checks the validity of objects for application "Application" in database account "Database account" depending on option flags:

•if "Check views" = 'Y', checks all Logical Views that are incorrect and active.

•if "Check table constraints" = 'Y', checks all table constraints.

•if "Check domain constraints" = 'Y', checks all domain constraints.

•if "Validate jobs" = 'Y', validates all jobs, but see Notes.

This is equivalent to pressing the Check button (for views and constraints) or the Validate button (for jobs) in USoft Definer.

Parameters

Name

Type

Optional?

Application

Application

No

Database account

Database account

No

Check views Y/N

Option flag

No

Check table constraints Y/N

Option flag

No

Check domain constraint Y/N

Option flag

No

Validate jobs Y/N

Option flag

No

Notes

When validating incorrect jobs, skips jobs listed in UDeliver's Application Jobs table with flag Skip Validation = Yes.