New Features in Adaptive Server 12.5.4

Adaptive Server 12.5.4 introduces security enhancements, archive database access support, changes to shared directories, support for new data providers, dynamically loaded TIBCO libraries, JRE support, modulo arithmetic for numeric datatypes, support for terminal server shared-memory requirements in Windows, and enhancements to login triggers.

• Kerberos Enhancements
  Adaptive Server 12.5.4 expands Kerberos capabilities
• LDAP User Authentication Enhancements
  Adaptive Server 12.5.4 supports enhanced LDAP user authentication capabilities
• Password Complexity Enhancements
  Adaptive Server version 12.5.4 lets you make rules about passwords for new logins or for reset passwords.
• Archive Database Access Support
  Archive database access enables a variety of operations to be performed directly on a database dump
• Shared Directory Changes
  Adaptive Server version 12.5.4 includes changes to the shared directory structure
• Sybase Driver Support
  Adaptive Server 12.5.4 supports new Adaptive Server Data Providers
• Dynamically Loaded TIBCO Libraries
  TIBCO JMS libraries are now dynamically loaded rather than statically linked to the Adaptive Server executable.
• JRE Support
  Adaptive Server 12.5.4 includes JRE 1.4.
• Adaptive Server Plug-in Changes
  Adaptive Server Plug-in supports archive database access and password complexity.
• Updating System Catalogs
  The server-wide command allow updates to system catalogs takes precedence over the stored procedure settings for allow updates.
• Monitoring Tables Changes
  Monitoring tables monSysStatement and monProcessStatement have been changed.
• syscomments Changes
  When the source text of a stored procedure or trigger is stored in the system table syscomments, a query using select * is stored in syscomments expanding the column-list referenced in the select *.
• Shared-Memory Support in Windows Terminal Server Environments
  To accommodate Windows terminal server shared-memory requirements, Adaptive Server 12.5.4 introduces the new environment variable SYBASE_TS_MODE.
• Global Login Trigger
  Adaptive Server version 12.5.4 provides the ability to set a new global login trigger that is executed at each user login.
• Exporting set Options from a Login Trigger
  Adaptive Server version 12.5.4 enables set options inside login triggers to remain valid for the entire user session.
• Modulo Arithmetic for Numeric Datatypes
  In Adaptive Server version 12.5.4, you can perform modulo arithmetic on reals, floats, decimals, numerics, as well as on integers.