Getting started

In UNIX, you enter a utility program command at the system prompt in a UNIX shell.

In Windows NT:

Place characters with special meaning to the shell (the command prompt in Windows NT), such as the backslash (\), asterisk (*), slash (/), and spaces, in quotes. You can precede some special characters with the backslash (\) to “escape” them. This prevents the shell (command prompt) from interpreting the special characters.

Table 6-1 describes the utility programs available with Adaptive Server.

NoteThe utility programs described in Table 6-1 may allow you to use a -P parameter to enter your password. If security is an issue, do not use this parameter to specify your password. Another user may have an opportunity to see it. Instead, log in as usual without the -P parameter, and let Adaptive Server prompt you for your password.

Table 6-1: Utility programs

Utility

Description

backupserver

Executable form of the Backup Server™ program.

bcp

Copies rows in a database table to or from an operating system file in a user-specified format.

certauth

Converts a server-certificate request into a certificate authority-signed certificate.

certpk12

Export or import a PKCS#12 file.

certreq

Creates a server certificate request and corresponding private key in two ways:

charset

Loads the character sets and sort order files.

cobpre

Precompiler for COBOL.

cpre

Precompiler for C.

dataserver

Executable form of the Adaptive Server program.

dataxtr

Data migration tool.

ddlgen

Generates data definition language for server- and database-level objects in ASE.

defncopy

Copies definitions for specified views, rules, defaults, triggers, procedures, or reports from a database to an operating system file or from an operating system file to a database.

dscp

Allows you to view and edit server entries in the interfaces file in command-line mode.

dsedit

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

extractjava

Copies a retained JAR from an Adaptive Server to a client file.

installjava

Installs a JAR from a client file into an Adaptive Server.

isql

Interactive SQL parser to Adaptive Server.

langinstall

Installs a new language on the Adaptive Server.

optdiag

Displays optimizer statistics or loads updated statistics into system tables.

pwdcrypt

Creates and prints an encrypted LDAP password in the libtcl.cfg file.

showserver

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

sqldbgr

Debugs stored procedures and triggers.

sqlloc

Installs and modifies languages, character sets, and sort order defaults for Adaptive Server in GUI mode.

sqllocres

Installs and modifies languages, character sets, and sort order defaults for Adaptive Server in command-line mode.

sqlsrvr

Executable form of the Adaptive Server program.

sqlupgrade

Upgrades your currently installed release of Adaptive Server to the newest release in GUI mode.

sqlupgraderes

Upgrades your currently installed release of Adaptive Server to the newest release in command-line mode.

srvbuild

Creates a new Adaptive Server, Backup Server, Monitor Server, or XP Server in GUI mode with default or user-specified values for key configuration attributes.

srvbuildres

Creates a new Adaptive Server, Backup Server, Monitor Server, or XP Server in command-line mode with default or user-specified values for key configuration attributes.

sqlsrvr

Executable form of the Adaptive Server program.

startserver

Starts an Adaptive Server or a Backup Server.

srvmgr

Starts Adaptive Server and Backup Server as Windows NT services.

sybload

Uploads Sybase products from the distribution media and builds the Sybase installation directory from the command line.

sybsetup

Installs and configures Adaptive Server from a single location using a GUI interface.

xpserver

Starts XP Server manually.