psCheckRules

Description

     This program checks whether your tables' columns violate their
check constraints and rules.   If you are concerned about the integrity
of your data, this program as well as psCheckRIConstraints are programs
which confirm or deny your suspicions.
     Bad data can enter your tables in many ways.   People can drop
the constraints.   Bulk copy operations ignore constraints.   And Mother
Nature herself can send a thunderbolt to corrupt the disk itself.
dbcc checks for acts of Mother Nature.  psCheckRIConstraints and
psCheckRules check for evil deeds done by users.
     This program generates a Korn shell script.  The script contains an
an embedded psSQL session.   The psSQL session runs SQL which lists the
rows which are violating their rules.

Syntax

psCheckRules -Sserver -Uusername -Ppassword -Ddatabase
-Wowner -Nname
-Vmax_violations_to_display -Rresults_file -Mresults_file_max_size
-Ooptions

-S

Source Sybase Server Name

-U

Source Sybase User Name

-P

Source Sybase User Password

-D

Source Sybase Database

-W

Check tables owned by 'owner' only [-U]

-N

Check tables having pattern 'name' [!rs%]

-V

Display up this many violations per table [50]

-F

Name of output Korn shell script [standard output]

-R

psSQL results file name [standard output]

-M

psSQL initial maximum size in bytes for results file [0]

-O

Options

c

Do not comment the results file

DSQUERY

When -S is not specified

SYB_USER

When -U is not specified

SYB_PASS

When -P is not specified

SYB_DATABASE

When -D is not specified

PS_SYSMSG_FILE

Name of the tool's messages file