Contents Index Servers and databases Defaults and rules

ASA SQL User's Guide
  Transact-SQL Compatibility
    Adaptive Server architectures

Device management


Adaptive Server Anywhere and Adaptive Server Enterprise use different models for managing devices and disk space, reflecting the different uses for the two products. While Adaptive Server Enterprise sets out a comprehensive resource management scheme using a variety of Transact-SQL statements, Adaptive Server Anywhere manages its own resources automatically, and its databases are regular operating system files.

Adaptive Server Anywhere does not support Transact-SQL DISK statements, such as DISK INIT, DISK MIRROR, DISK REFIT, DISK REINIT, DISK REMIRROR, and DISK UNMIRROR.

For information on disk management, see Working with Database Files


Contents Index Servers and databases Defaults and rules