psFindProcedure

Description

    This program finds a stored procedure, extended stored procedure
or java function in a Sybase ASE server.  The program lists all databases
and owners who own the procedure or function matching your pattern.

 

Syntax

psFindProcedure -Sserver -Uusername -Ppassword
-Ddatabase_pattern -Wproc_func_owner_pattern -Nprocedure_name_pattern
-Flog_file

 

Arguments

-S

Sybase Server Name

-U

Sybase User Name

-P

Sybase User's Password

-D

Sybase Database Name Pattern [~tempdb ~model]

-W

Sybase Procedure/Function Owner Pattern [%]

-N

Sybase Procedure/Function Name Pattern [%]

-F

Log File [standard output]

 

Environment Variables Behind the Scenes

DSQUERY

When -S is not specified.

SYB_USER

When -U is not specified.

SYB_PASS

When -P is not specified.

PS_SYSMSG_FILE

Name of the tool's messages file.

 

Go to DBPowerSuite 7.9 List of Programs.


Updated: Thu Jun 18 21:12:26 2009