The new features and system changes in Adaptive Server version 12 are:
Category
Name
Availability and Manageability
“Sybase’s Failover for a high availability system”
“Rebuilding indexes”
“High performance backup and restore”
“Non-rewinding tapes”
“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”
“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”
System Changes
“System changes in version 12”
