psCopyProcedures

Description

     This program copies procedures and functions from one schema to another.  This
program can only copy procedures of a single owner at a time.

Syntax

psCopyProcedures -Sserver -Uusername -Ppassword -Ddatabase
-Wowner -Nname
-starget_server -utarget_username -ptarget_pass -dtarget_db
-FKorn_script -Rresults_file -Mresults_file_max_size
-Ooptions

-S

Sybase Server Name

-U

Sybase User Name

-P

Sybase User's Password

-D

Sybase Database

-W

Copy procedures belonging to owner only [-U]

-N

Copy procedures whose name has pattern 'name' [!rs%]

-s

Target Sybase Server

-u

Target Sybase User Name

-p

Target Sybase User's Password

-d

Target Sybase Database

-w

Target Procedure Owner [-u]

-F

Name of output Korn shell script. [standard output]

-R

Results file for psSQL [standard output]

-M

Maximum size of results file [0]

-O

Options

y

Ignore creation dependencies on other procedures

e

Ignore all Sybase errors.  Always return successful from psSQL.

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.