The new features and system changes in Adaptive Server version 12.0 are:
Category
Feature
Availability and manageability
“Sybase Failover for a high availability system”
“Rebuilding indexes”
“New Backup Server features”
“UNIX file system support”
“Modifying an existing table’s schema with alter table”
“Suspending database updates with quiesce database”
“Taking Adaptive Server engines offline”
“User settable process information”
“Removed limit for number of fragments per database”
“Identity number gap for tables”
“Diagnostic database”
Performance and productivity
“Java in Adaptive Server Enterprise”
“Number of tables in a query”
“Query processing and optimization enhancements”
“ANSI joins”
“Dynamic execution of Transact-SQL”
“text and image datatype enhancements”
“Abstract plans”
“Disabling triggers”
“Cache partitions”
Distributed processing
“Distributed Transaction Management”
“Enhancements to Component Integration Services (CIS)”
Security
“Network security”
“User-defined login security”
“Concrete identification”
