Database creation and manipulation utilities

Use the following utilities to create and manipulate databases:

bcp

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

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.

extractjava

Copies a retained JAR and the classes it contains from an Adaptive Server to a client file.

installjava

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

isql

Interactive SQL parser to Adaptive Server.

optdiag

Displays optimizer statistics or loads updated statistics into system table.