psGenerateRITriggers

Description

     This program writes a script which creates update, insert
an delete referential integrity triggers for user tables based
on keys established by the SQL procedure sp_foreignkey.  Optionally,
you can choose to use keys defined by sp_commonkey instead.

Syntax

psGenerateRITriggers -Sserver -Uusername -Ppassword -Ddatabase
-Wowner -Nname
-FKorn_script -Rresults_file -Mmax_size_results_file

-S

Sybase Server Name

-U

Sybase User Name

-P

Sybase User's Password

-D

Sybase Database

-W

Create triggers for tables owned by 'owner' only

-N

Create triggers for tables whose name have pattern 'name' [!rs%]

-F

Name of output UNIX Korn shell script [standard output]

-R

psSQL results file [standard output]

-M

Maximum size in bytes of psSQL results file [0]

-O

Options

j

Generate triggers based on sp_commonkeys, not sp_foreignkeys

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.