psCopyRIConstraints

Description

     This program writes a Korn Shell script which adds referential integrity
constraints back to user tables in a database.

Syntax

psCopyRIConstraints -Sserver -Uusername -Ppassword -Ddatabase
-Wowner -Nname
-starget_server -utarget_username -ptarget_password
-dtarget_database -wtarget_owner
-FKorn_script -Rresults_file -Mmax_size_results_file
-Ooptions

-S

Sybase Server Name

-U

Sybase Username

-P

Sybase User's Password

-D

Sybase Database

-W

Use tables belonging to 'owner' only

-N

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

-s

Target Sybase server name [-S]

-u

Target Sybase username [-U]

-p

Target Sybase password [-P]

-d

Target Sybase database [-D]

-w

Target Sybase table owner [-W]

-F

Name of output Korn shell script [standard output]

-R

psSQL results file [standard output]

-M

Maximum size in bytes of psSQL results file [0]

-O

Options

x

Just add the constraints which cross databases.

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.