psCheckRIConstraints

Description

     This program writes a script to check the referential integrity of
user tables in a database.   Such a check is required if you are using
constraints and you have bulk copied data into the tables.  When loading
data into tables using bcp, bcp ignores referential integrity constraints.

Syntax

psCheckRIConstraints -Sserver -Uusername -Ppassword -Ddatabase
-Wowner -Nname -Vviolations
-FKorn_script -Rresult_file -Mresults_file_max_size
-Ooptions

-S

Sybase Server Name

-U

Sybase User Name

-P

Sybase User's Password

-D

Sybase Database

-W

Use tables belonging to 'owner' only

-N

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

-V

Stop checking table after this number of violations [50]

-F

Name of output Korn shell script [standard output]

-R

Name of psSQL's results file [standard output]

-M

Maximum size of psSQL's results file [0]

-O

Options

c

Do not comment the results file

x

Just check those constraints which cross databases

r

Just check normal RI constraints (default)

k

Just check foreign keys defined by sp_foreignkey

j

Just check keys defined with sp_commonkey

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.