Quick Reference Guide for ASE

Unix Utilities

backupserver backupserver - The executable form of the Backup Server program. backupserver [-Cserver_connections] [-Sb_servername] [-Iinterfaces_file] [-eerror_log_file] [-Msybmultbuf_binary] [-Nnetwork_connections] [-Ttrace_value] [-LSybase_language_name] [-JSybase_character_set_name] [-ctape_config_file] [-V{0|1|2|3}] or backupserver -v

bcp bcp - Copies a database table to or from an operating system file in a user- specified format. bcp [[database_name.]owner.][view_name | table_name [:partition_id]] {in | out} datafile [-c] [-E] [-n] [-N] [-X] [-a display_charset] [-A packet_size] [-b batchsize] [-e errfile] [-f formatfile] [-g id_start_value] [-I interfaces_file] [-J client_charset] [-m maxerrors] [-P password] [-q datafile_charset] [-R remote_server_principal] [-S server] [-t field_terminator] [-T text_or_image_size] [-U username] [-z language] or bcp -v

buildmaster buildmaster - Builds the master device and creates the master, model, and tempdb databases on the device. buildmaster [-d disk] [-c cno] [-s size] [-m] [-r] [-q] [-x] or buildmaster -v

dataserver dataserver - The executable form of the Adaptive Server program. dataserver -ddevicename [-cconfigurationfile] [-eerrorlogfile] [-m] [-rmastermirror] [-Msharedmem_directory] [-iinterfaces_file_directory] [-sservername] [-psso_login_name] or dataserver -v

defncopy defncopy - Copies definitions for specified views, rules, defaults, triggers, or procedures from a database to an operating system file or from an operating system file to a database. The defncopy utility cannot copy table definitions or reports created with Report Workbench. defncopy [-X] [-a display_charset] [-I interfaces_file] [-J [client_charset]] [-P password] [-R remote_server_principal] [-S [server]] [-U username] [-z language] {in filename dbname | out filename dbname [owner.]objectname [[owner.]objectname...] } or defncopy -v

dscp dscp - Allows you to view and edit server entries in the interfaces file from the command line. dscp [-p] or dscp -v To exit from dscp: quit or exit

dsedit dsedit - Allows you to view and edit server entries in the interfaces file using a graphical user interface based on X11/Motif. dsedit or dsedit -v

isql isql - Interactive SQL parser to Adaptive Server. isql [-b] [-e] [-F] [-n] [-p] [-X] [-Y] [-a display_charset] [-A size] [-c cmdend] [-D database] [-E editor] [-h headers] [-H hostname] [-i inputfile] [-I interfaces_file] [-J client_charset] [-l login_timeout] [-m errorlevel] [-o outputfile] [-P password] [-R remote_server_principal] [-s colseparator] [-S server] [-t timeout] [-U username] [-w columnwidth] [-z language] or isql -v 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 langinstall - Installs a new language in an Adaptive Server. langinstall [-S server] [-I interfaces_file] [-P password] [-R release_number] language character_set or langinstall -v

optdiag optdiag - Displays optimizer statistics or loads updated statistics into system tables. optdiag [ binary ] [simulate ] statistics { -i input_file | database[.owner[.[table[.column]]]] [-o output_file] } [-U username] [-P password] [-I interfaces_file] [-S server] [-v] [-h] [-Tflag_value] [-z language] [-J client_charset] [-a display_charset]

showserver showserver - Shows the Adaptive Servers and Backup Servers that are currently running on the local machine. showserver

sqlloc sqlloc - Installs and modifies languages, character sets, and sort order defaults for Adaptive Server using a graphical user interface based on X11/Motif. sqlloc [-S server] [-U user] [-P password] [-s sybase_dir] [-I interfaces_file] [-r resource_file] or sqlloc -v

sqllocres sqllocres - Installs and modifies languages, character sets, and sort order defaults for Adaptive Server, using a resource file. sqllocres [-S server] [-U user] [-P password] [-s sybase_dir] [-I interfaces_file] [-r resource_file] or sqllocres -v

sqlupgrade sqlupgrade - Upgrades your currently installed release of Adaptive Server to the newest release using a graphical user interface based on X11/Motif. sqlupgrade [-s sybase_dir] [-r resource_file] or sqlupgrade -v

sqlupgraderes sqlupgraderes - Upgrades your currently installed release of Adaptive Server to the newest release using resource files. sqlupgraderes [-s sybase_dir] [-r resource_file] or sqlupgraderes -v

srvbuild srvbuild - Creates a new Adaptive Server, Backup Server, Monitor Server, or XP Server with default or user-specified values for key configuration attributes using a graphical user interface based on X11/Motif. srvbuild [-s sybase_dir] [-I interfaces_file] [-r resource_file] or srvbuild -v

srvbuildres srvbuildres - Creates, using resource files, a new Adaptive Server, Backup Server, Monitor Server, or XP Server with default or user-specified values for key configuration attributes. srvbuildres [-s sybase_dir] [-I interfaces_file] [-r resource_file] or srvbuildres -v

startserver startserver - Starts an Adaptive Server and/or a Backup Server. startserver [[-f runserverfile] [-m]] ...

sybload sybload - Uploads Sybase products from the distribution media and builds the Sybase installation directory. sybload [-D]

sybsetup sybsetup - Installs and configures Adaptive Server from a single location using a graphical user interface based on X11/Motif. sybsetup [-c devicename] [-t devicename] [-l local_source] [-r remote_source]

Goto Top

backupserver	backupserver - The executable form of the Backup Server program. backupserver [-Cserver_connections] [-Sb_servername] [-Iinterfaces_file] [-eerror_log_file] [-Msybmultbuf_binary] [-Nnetwork_connections] [-Ttrace_value] [-LSybase_language_name] [-JSybase_character_set_name] [-ctape_config_file] [-V{0\|1\|2\|3}] or backupserver -v
bcp	bcp - Copies a database table to or from an operating system file in a user- specified format. bcp [[database_name.]owner.][view_name \| table_name [:partition_id]] {in \| out} datafile [-c] [-E] [-n] [-N] [-X] [-a display_charset] [-A packet_size] [-b batchsize] [-e errfile] [-f formatfile] [-g id_start_value] [-I interfaces_file] [-J client_charset] [-m maxerrors] [-P password] [-q datafile_charset] [-R remote_server_principal] [-S server] [-t field_terminator] [-T text_or_image_size] [-U username] [-z language] or bcp -v
buildmaster	buildmaster - Builds the master device and creates the master, model, and tempdb databases on the device. buildmaster [-d disk] [-c cno] [-s size] [-m] [-r] [-q] [-x] or buildmaster -v
dataserver	dataserver - The executable form of the Adaptive Server program. dataserver -ddevicename [-cconfigurationfile] [-eerrorlogfile] [-m] [-rmastermirror] [-Msharedmem_directory] [-iinterfaces_file_directory] [-sservername] [-psso_login_name] or dataserver -v
defncopy	defncopy - Copies definitions for specified views, rules, defaults, triggers, or procedures from a database to an operating system file or from an operating system file to a database. The defncopy utility cannot copy table definitions or reports created with Report Workbench. defncopy [-X] [-a display_charset] [-I interfaces_file] [-J [client_charset]] [-P password] [-R remote_server_principal] [-S [server]] [-U username] [-z language] {in filename dbname \| out filename dbname [owner.]objectname [[owner.]objectname...] } or defncopy -v
dscp	dscp - Allows you to view and edit server entries in the interfaces file from the command line. dscp [-p] or dscp -v To exit from dscp: quit or exit
dsedit	dsedit - Allows you to view and edit server entries in the interfaces file using a graphical user interface based on X11/Motif. dsedit or dsedit -v
isql	isql - Interactive SQL parser to Adaptive Server. isql [-b] [-e] [-F] [-n] [-p] [-X] [-Y] [-a display_charset] [-A size] [-c cmdend] [-D database] [-E editor] [-h headers] [-H hostname] [-i inputfile] [-I interfaces_file] [-J client_charset] [-l login_timeout] [-m errorlevel] [-o outputfile] [-P password] [-R remote_server_principal] [-s colseparator] [-S server] [-t timeout] [-U username] [-w columnwidth] [-z language] or isql -v 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	langinstall - Installs a new language in an Adaptive Server. langinstall [-S server] [-I interfaces_file] [-P password] [-R release_number] language character_set or langinstall -v
optdiag	optdiag - Displays optimizer statistics or loads updated statistics into system tables. optdiag [ binary ] [simulate ] statistics { -i input_file \| database[.owner[.[table[.column]]]] [-o output_file] } [-U username] [-P password] [-I interfaces_file] [-S server] [-v] [-h] [-Tflag_value] [-z language] [-J client_charset] [-a display_charset]
showserver	showserver - Shows the Adaptive Servers and Backup Servers that are currently running on the local machine. showserver
sqlloc	sqlloc - Installs and modifies languages, character sets, and sort order defaults for Adaptive Server using a graphical user interface based on X11/Motif. sqlloc [-S server] [-U user] [-P password] [-s sybase_dir] [-I interfaces_file] [-r resource_file] or sqlloc -v
sqllocres	sqllocres - Installs and modifies languages, character sets, and sort order defaults for Adaptive Server, using a resource file. sqllocres [-S server] [-U user] [-P password] [-s sybase_dir] [-I interfaces_file] [-r resource_file] or sqllocres -v
sqlupgrade	sqlupgrade - Upgrades your currently installed release of Adaptive Server to the newest release using a graphical user interface based on X11/Motif. sqlupgrade [-s sybase_dir] [-r resource_file] or sqlupgrade -v
sqlupgraderes	sqlupgraderes - Upgrades your currently installed release of Adaptive Server to the newest release using resource files. sqlupgraderes [-s sybase_dir] [-r resource_file] or sqlupgraderes -v
srvbuild	srvbuild - Creates a new Adaptive Server, Backup Server, Monitor Server, or XP Server with default or user-specified values for key configuration attributes using a graphical user interface based on X11/Motif. srvbuild [-s sybase_dir] [-I interfaces_file] [-r resource_file] or srvbuild -v
srvbuildres	srvbuildres - Creates, using resource files, a new Adaptive Server, Backup Server, Monitor Server, or XP Server with default or user-specified values for key configuration attributes. srvbuildres [-s sybase_dir] [-I interfaces_file] [-r resource_file] or srvbuildres -v
startserver	startserver - Starts an Adaptive Server and/or a Backup Server. startserver [[-f runserverfile] [-m]] ...
sybload	sybload - Uploads Sybase products from the distribution media and builds the Sybase installation directory. sybload [-D]
sybsetup	sybsetup - Installs and configures Adaptive Server from a single location using a graphical user interface based on X11/Motif. sybsetup [-c devicename] [-t devicename] [-l local_source] [-r remote_source]