psGenerateRIMap

Description

     This program makes a text file of tables and their referential integrity
constraints map (RI Map) for input into programs like psGTruncateTable.

Syntax

psGenerateRIMap -Sserver -Uusername -Ppassword -Ddatabase
-Wowner -Nname
-Foutput_RI_map -Ooptions

-S

Source Sybase Server Name

-U

Source Sybase User Name

-P

Source Sybase User Password

-D

Source Sybase Database

-W

Use tables belonging to 'owner' only

-N

Use tables having pattern 'name'

-F

Name of output RI map file for psGTruncateTables [standard output]

-O

Options

c

Generate the list in order that the tables were created

r

Generate the list in reverse order that the tables were created

i

Generate the list with incoming referential integrity constraints

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