psUpdateStatistics

Description

     This program writes a Korn shell which contains SQL
commands to update statistics and sp_recompile tables in
a database.  You should run this program and script regularly
when changes are occurring in your tables.

Syntax

psUpdateStatistics -Sserver -Uusername -Ppassword -Ddatabase
-Wowner -Nname
-FKorn_script -Rresults_file -Mresults_file_max_size
-Ooptions

-S

Sybase Server Name

-U

Sybase User Name

-P

Sybase User Password

-D

Sybase Database

-W

Update statistics on tables belonging to 'owner' only

-N

Update statistics on tables having pattern 'name'

-F

Name of output Korn shell script [standard output]

-R

psSQL results file name [standard output]

-M

psSQL initial max size in bytes for results file [0]

-O

Options

s

Update statistics for system tables too

a

Update 'all' statistics

x

Execute the script immediately

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