Adaptive Server Enterprise

An Adaptive Server Enterprise database can be unloaded and reloaded as long as the system is quiet and the transaction log is fully scanned.

Use this statement to set database options for the current connection in an Adaptive Server Enterprise-compatible manner.

For a list of these system procedures see Adaptive Server Enterprise system and catalog procedures.

With the quoted_identifier option set to ON, Adaptive Server Enterprise allows table, view, and column names to be delimited by quotes.

The Adaptive Server Enterprise driver is a wire protocol driver, which means that there is no additional client software required.

None of the other clauses are supported in Adaptive Server Enterprise stored procedures.

The System Administrator in Adaptive Server Enterprise enjoys this permission for all databases on a server.

Adaptive Server Enterprise and Adaptive Server Anywhere have different system catalogs, reflecting the different uses for the two products.

This applies also to upgrading maintenance releases of the Adaptive Server Enterprise or Adaptive Server Anywhere database software.

Other object names cannot be delimited in Adaptive Server Enterprise.

This data type is convenient for storing monetary data, and provides compatibility with the Adaptive Server Enterprise MONEY data type.

This section describes how the Message Agent for Adaptive Server Enterprise works.

Adaptive Server Enterprise does not support explicit estimates.

A closely corresponding Adaptive Server Enterprise permission is GRANT ALL, used by a Database Owner.

Some database objects occupy different name spaces in Adaptive Server Enterprise and Adaptive Server Anywhere.

The EXISTS condition is compatible between Adaptive Server Enterprise and Adaptive Server Anywhere.

In Adaptive Server Enterprise, each database exists inside a server, and each server can contain several databases.

The quoted_identifier option is provided for compatibility with Adaptive Server Enterprise.

For more information on the stable queue, see How the Message Agent for Adaptive Server Enterprise works.

If language_name and charset_name are not supplied, the Message Agent obtains them from Adaptive Server Enterprise.

For compatibility with Adaptive Server Enterprise, you can set the QUOTED_IDENTIFIER database option to OFF.

Adaptive Server Enterprise has a less restrictive name space for index names than Adaptive Server Anywhere.

For information on this procedure, see SQL Remote Design for Adaptive Server Enterprise.

The double-hyphen and the slash-asterisk comment styles are compatible with Adaptive Server Enterprise.

The Adaptive Server Enterprise LTM sends data changes to the Replication Server before they are committed.

DATETIME is provided primarily for compatibility with Adaptive Server Enterprise.

Adaptive Server Anywhere does support some Adaptive Server Enterprise options using the SET statement.

It is provided primarily for compatibility with Adaptive Server Enterprise.

Ssxtract is the extraction utility for Adaptive Server Enterprise, dbxtract is the extraction utility for Adaptive Server Anywhere.

Both Adaptive Server Enterprise and Adaptive Server Anywhere have a public group, for defining default permissions.

If you wish to ensure compatibility with Adaptive Server Enterprise, you should use quoted aliases of 30 bytes or less.

In Adaptive Server Enterprise, removes a user from the server.

In Adaptive Server Enterprise, replication options are used only by SQL Remote.

In Adaptive Server Enterprise, this adds a user to the server.

There are some differences between the Adaptive Server Enterprise and Adaptive Server Anywhere models of users and groups.

For compatible SQL, you should stay within the Adaptive Server Enterprise restriction and make your trigger names unique in the database.

You have installed an Adaptive Server Enterprise server that is to contain the SQL Remote database.

You have created a database in the Adaptive Server Enterprise server that will take part in your SQL Remote installation.

One row for each primary, foreign, or common key; set by the user (not maintained by Adaptive Server Enterprise)

Options for Open Client and JDBC connection compatibility with Adaptive Server Enterprise

The following statements set the Verify_all_columns option to OFF in Adaptive Server Enterprise

Using the extraction utility for Adaptive Server Enterprise