psBindDefaults

Description

     This program binds table columns to defaults.   Only those
columns that were bound to defaults created by 'create default'
will have sp_bindefault statements generated.

 

Syntax

psBindDefaults -Sserver -Uusername -Ppassword -Ddatabase
-Wdefault_owner -Ndefault_name -Vtable_owner -Ttable_name
-starget_server -utarget_username -ptarget_pass -dtarget_db
-wtarget_default_owner -vtarget_table_owner
-FKorn_script -Rresults_file -Mresults_file_max_size

 

Arguments

-S

Sybase Server Name

-U

Sybase User Name

-P

Sybase User's Password

-D

Sybase Database

-W

Bind defaults owned by pattern 'default_owner' [-U]

-N

Bind defaults named by pattern 'default_name'

-V

Bind defaults to those tables belonging to owner only [-U]

-T

Bind defaults to those tables named 'name'

-s

Target Sybase Server [-S]

-u

Target Sybase User Name [-U]

-p

Target Sybase User's Password [-P]

-d

Target Sybase Database [-D]

-v

Target Table Owner [-V]

-F

Name of output Korn shell script [standard output]

-R

Results file for psSQL [standard output]

-M

Maximum size of results file [0]

 

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.

SYB_DATABASE

When -D 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