psTruncateTables

Description

     This program truncates user tables in a database.  System
tables are not touched.  Before you truncate the tables, you
might have to first consider dropping the referential
integrity constraints with psDropRIConstraints.

Syntax

psTruncateTables -Sserver -Uusername -Ppassword -Ddatabase
-Wowner -Nname
-FKorn_script -Rresults_file -Mresults_file_max_size

-S

Sybase Server Name

-U

Sybase User Name

-P

Sybase User Password

-D

Sybase Database

-W

Truncate tables belonging to 'owner' only

-N

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

-F

Name of output Korn shell script [standard output]

-R

psSQL results file name [standard output]

-M

Initial results file maximum size in bytes [0]

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.