Utilities

See Utility Guide for details.

backupserver

bcksrvr.exe in Windows NT

backupserver
	[-C server_connections]
	[-S b_servername]
	[-I interfaces_file]
	[-e error_log_file]
	[-M sybmultbuf_binary]
	[-N network_connections]
	[-T trace_value]
	[-L Sybase_language_name]
	[-J Sybase_character_set_name]
	[-c tape_config_file]
	[-D n]
	[-A pathname]
	[-P active_service_threads]
	[-V level_number]
	[-p n]
	[-m max_shared_memory]

Or

backupserver -v

bcp

Also use for bcp_r, bcp_dce

bcp [[database_name.]owner.]table_name [:slice_number] {in | out} datafile 
	[-m maxerrors]
	[-f formatfile]
	[-e errfile] 
	[-F firstrow]
	[-L lastrow]
	[-b batchsize]
	[-n]
	[-c]
	[-t field_terminator]
	[-r row_terminator]
	-U username
	[-P password]
	[-I interfaces_file]
	[-S server]
	[-a display_charset]
	[-z language]
	[-A packet_size]
	[-J client_charset]
	[-T text_or_image_size]
	[-E]
	[-g id_start_value]
	[-N]
	[-X]
	[-K keytab_file]
	[-R remote_server_principal]
	[-V [security_options]]
	[-Z security_mechanism]
	[-Q]
	[-Y]

Or

bcp -v

buildmaster

See dataserver for UNIX, or sqlsrvr for Windows NT.

certauth

certauth
	[-r]
	[-C caCert_file]
	[-Q request_filename]
	[-K caKey_filename]
	[-O SignedCert_filename]
	[-P caPassword]
	[-T valid_time]

Or

certauth -v

certpk12

certpk12
	{-O Pkcs12_file | -I Pkcs12_file}
	[-C Cert_file]
	[-K Key_file]
	[-P key_password]
	[-E Pkcs12_password]

Or

certpk12 -v

certreq

certreq
	[-F input_file]
	[-R request_filename]
	[-K PK_filename]
	[-P password]

Or

certreq -v

charset

UNIX platforms only.

charset
	[-Ppassword]
	[-Sserver]
	[-Iinterface]
	sort_order
	[ charset ]

Or

charset -v

cobpre

Also use for cobpre_r and copbre_dce.

cobpre [ -a ] [ -b ] [ -c ] [ -d ] [ -e ] 
	[ -f ] [ -h ] [ -m ] [ -p ] [ -q ] [ -r ] 
	[ -v ] [ -w ] [ -x ] 
	[ -B compatibility_mode ] 
	[ -C compiler ]
	[ -D database ] 
	[ -F fips_level ] 
	[ -G [isql_file_name] ]
	[ -I include_path_name ] 
	[ -J charset_locale_name ]
	[ -K syntax_level ] 
	[ -L [listing_file_name] ]
	[ -N interfacefile_name ] 
	[ -O target_file_name ]
	[ -P password ] 
	[ -S server_name ] 
	[ -T tag ] 
	[ -U userid ]  
	[ -V version_number ] 
	[ -X application_name ] 
	[ -Z language_locale_name ] 
	[ @options_file ]
	filename[.ext] ...

cpre

Also use for cpre_r and cpre_dce.

cpre [ -a ] [ -b ] [ -c ] [ -d ] [ -f ] [ -h ] 
	[ -l ] [ -m ] [ -p ] [ -r ] [ -s ] [ -v ] 
	[ -w ] [ -x ] 
	[ -B compatibility_mode ]
	[ -C compiler ]
	[ -D database ]
	[ -F fips_level ]
	[ -G [isql_file_name] ]
	[ -I include_path_name ]
	[ -J charset_locale_name ]
	[ -K syntax_level ]
	[ -L [listing_file_name] ]
	[ -N interfacefile_name ]
	[ -O target_file_name ]
	[ -P password ]
	[ -S server_name ]
	[ -T tag ]
	[ -U userid ]
	[ -V version_number ]
	[ -X application_name ]
	[ -Z language_locale_name ]
	[ @options_file ]
	filename[.ext]

dataserver

UNIX platforms only.

dataserver [-f] [-g] [-G] [-h] [-H] [-m] [-q] [-v] [-X]
	[-a path_to_CAPs_directive_file]
	-b master_device_size [k | K | m | M | g | G]
	[-c config_file_for_server]
	[-d device_name]
	[-e path_to_error_log]
	[-i interfaces_file_directory]
	[-K keytab_file]
	[-L config_file_name_for_connectivity]
	[-M shared_memory_repository_directory]
	[-p sa_login_name]
	[-r mirror_disk_name]
	[-s server_name]
	[-T trace_flag]
	[-u sa/sso_name]
	[-w master | model database]
	[-y [password] ]
	[-z page_size [ k | K ] ]

Or

dataserver -v

ddlgen

ddlgen 
	-Ulogin
	-Ppassword
	-Shost_name : port_number
	[-Tobject_type]

For a list of valid object types, see “ddlgen” in the Utility Guide.

	[-Nobject_name]
	[-Ddbname]
	[-Xextended_object_type]
	[-Ooutput_file]
	[-Eerror_file]
	[-Lprogress_log_file]
	[-Jclient_charset]
	-F[ % | SGM | GRP | USR | R | D | UDD | U | V | P | XP | I | RI | KC | TR]

Or

ddlgen -v

defncopy

Also use for defncopy_r, defncopy_dce.

defncopy
	[-X]
	[-a display_charset]
	[-I interfaces_file]
	[-J [client_charset]]
	[-K keytab_file]
	[-P password]
	[-R remote_server_principal]
	[-S [server_name]]
	[-U username]
	[-V security_options]
	[-Z security_mechanism]
	[-z language]
	{ in file_name database_name | 
		out file_name database_name [owner.]object_name
		 [[owner.]object_name...] }

Or

defncopy -v

dscp

Also use for dscp_r, dscp_dce.

dscp [-p]

or

dscp -v

To exit from dscp:

quit

or

exit

dsedit

Also use for dsedit_r, dsedit_dce.

dsedit

or

dsedit -v

extractjava

extrjava.exe in Windows NT.

extractjava (extrjava in Windows NT)
	-j jar_name
	-f file_name
	[-S server_name]
	[-U user_name]
	[-P password]
	[-D database_name]
	[-I interfaces_file]
	[-a display_charset]
	[-J client_charset]
	[-z language]
	[-t timeout]
	[-v]

Or

extractjava -v

installjava

instjava.exe in Windows NT.

installjava
	-f file_name
	[ -new | -update ]
	[ -j jar_name ]
	[ -S server_name ]
	[ -U user_name ]
	[ -P password ]
	[ -D database_name ]
	[ -I interfaces_file ]
	[ -a display_charset ]
	[ -J client_charset ]
	[ -z language ]
	[ -t timeout ]
	[-v]

Or

installjava -v

isql

Also use for isql_r, isql_dce.

isql [-b] [-e] [-F] [-p] [-n] [-v] [-X] [-Y] [-Q]
	[-a display_charset]
	[-A packet_size]
	[-c cmdend]
	[-D database]
	[-E editor]
	[-h headers]
	[-H hostname]
	[-i inputfile]
	[-I interfaces_file]
	[-J client_charset]
	[-K keytab_file]
	[-l login_timeout]
	[-m errorlevel]
	[-o outputfile]
	[-P password]
	[-R remote_server_principal]
	[-s colseparator]
	[-S server_name]
	[-t timeout]
	-U username
	[-V [security_options]]
	[-w columnwidth]
	[-z locale_name]
	[-Z security_mechanism]

• To terminate a command:

  go
  

• To clear the query buffer:

  reset
  

• To call the default editor:

  vi
  

• To execute an operating system command:

  !! command
  

• To exit from isql:

  quit
  

  or

  exit
  

langinstall

langinst.exe in Windows NT.

langinstall
	[-S server]
	[-U user]
	[-I interfaces_file]
	[-P password]
	[-R release_number]
	[-I path_to_interfaces_file]
	language
	character_set

Or

langinstall -v

optdiag

optdiag [binary] [simulate] statistics
	{ -i input_file |
		database[.owner[.[table[.column] ] ] ] [-o output_file] }
	[-U user_name]
	[-P password]
	[-T trace_value]
	[-I interfaces_file]
	[-S server]
	[-v]
	[-h]
	[-s]
	[-z language]
	[-J client_character_set]
	[-a display_charset]

pwdcrypt

pwdcrypt

showserver

showserver

sqldbgr

sqldbgr
	-U username
	-P password
	-S host:port

sqlloc

sqlloc
	[-S Server]
	[-U User]
	[-P Password]
	[-s Sybase Dir]
	[-I Interfaces file]
	[-r Resource file]

Or

sqlloc -v

sqllocres

sqllocres
	[-S Server]
	[-U User]
	[-P Password]
	[-s Sybase Dir]
	[-I Interfaces file]
	[-r Resource file]

Or

sqllocres -v

sqlsrvr

Windows NT only.

sqlserver [-f] [-g] [-G] [-h] [-H] [-m] [-P] [-q] [-v] [-X]
	[-a path_to_CAPs_directive_file]
	[-b master_device_size]
	[-c config_file_for_server]
	[-d device_name]
	[-e path_to_error_log]
	[-i interfaces_file_directory]
	[-K keytab_file]
	[-L config_file_name_for_connectivity]
	[-M shared_memory_repository_directory]
	[-p sa_login_name]
	[-r mirror_disk_name]
	[-s server_name]
	[-T trace_flag]
	[-u sa/sso_name]
	[-w master | model database]
	[-y [password] ]
	[-z page_size [ k | K ] ]

sqlupgrade

sqlupgrade
	[-s Sybase Dir]
	[-r Resource File]

Or

sqlupgrade -v

sqlupgraderes

sqlupgraderes
	[-s Sybase Dir]
	[-r Resource File]

Or

sqlupgraderes -v

srvbuild

srvbuild
	[-s sybase_dir]
	[-I interfaces_file]
	[-r resource_file]

Or

srvbuild -v

srvbuildres

srvbuildres
	[-ssybase_dir]
	[-Iinterfaces_file]
	[-rresource_file]

Or

srvbuildres -v

startserver

startserver [[-f runserverfile] [-m]] ...

sybmigrate

sybmigrate [-v ] [-h ] [-f ]
	[-D 1 | 2 | 3 | 4 ]
	[-I interfaces file ]
	[-r input resource file ]
	[-m setup | migrate | validate | report ]
	[-rn status | space_est | repl | diff | password ]
	[-l log file ]
	[-t output template resource file ]
	[-J client_charset ]
	[-z language ]
	[-T trace_flags ]
	[-Tase trace flags ]
	[-f ]

xpserver

xpserver -S XP_Server

xpserver
 -SXP_Server
	[-Iinterfaces_file]
	[-ppriority]
	[-sstack_size]
	[-u]
	[-v]
	[-x]