New Features in Dynamic Server, Version 10.0

This section lists new features relevant to this manual. In addition to documenting new features, this manual corrects errata that have been identified since the previous edition.

This manual describes the following new features:

• Creating and dropping indexes without locking tables

  The SQL syntax of CREATE INDEX and DROP INDEX now supports the new ONLINE keyword.

• Managing database permissions through default roles

  You can create a default role and assign that role to individual users or to PUBLIC on a per-database level.

• Restricting registration of external routines

  The DBSA (Database Server Administrator) can use a new built-in role, called EXTEND, to specify which users can register UDRs that include the EXTERNAL NAME clause.

• Cross-database support for built-in opaque data types

  There is no cross-database support for complex data types. They can only be manipulated in local databases.

• Column-level encryption

  You can use the new SQL statement, SET ENCRYPTION PASSWORD, to implement column-level encryption to improve the confidentiality of the data. New built-in functions provide methods for encrypting and decrypting data.

For a comprehensive list of new database server features, see the IBM Informix: Getting Started Guide.