Informix Guide to SQL: Tutorial Introduction

For a comprehensive list of new database server features, see the release notes. This section lists new features relevant to this manual.

This manual describes new features in Version 8.3 of Enterprise Decision Server. The features fall into the following areas:

• Performance enhancements
• New SQL functionality
• Version 8.3 features from Dynamic Server 7.30

This manual describes the following performance enhancements to Version 8.3 of Enterprise Decision Server:

• Coarse-grain index locks
• Updates with subquery in SET clause

This manual describes the following new SQL functionality in Version 8.3 of Enterprise Decision Server:

• DELETE ... USING statement to delete rows based on a table join
• Load and unload simple large objects to external tables
• TRUNCATE statement

This manual describes the following features from Version 7.3 of Dynamic Server in Version 8.3 of Enterprise Decision Server:

• Ability to retain update locks
• COUNT function
• Insert from SPL procedures
• NVL and DECODE functions
• REPLACE, SUBSTR, LPAD, and RPAD functions for string manipulation
• Slow ALTER TABLE
• TO_CHAR and TO_DATE functions for date conversion
• Triggers
• UPDATE SET clause subqueries
• UPPER, LOWER, and INITCAP functions for case-insensitive search
• Violations table

This manual describes new features in Version 9.2 of Dynamic Server. The features fall into the following areas:

• Extensibility enhancements
• Performance improvements
• Special features

This manual describes the following extensibility enhancements to Version 9.2 of Dynamic Server:

• Enhancements to the database server: dynamic lock allocation
• General enhancements to SQL:
• Embedded newline characters in quoted strings
• Nested dot expressions
• Triggers on SELECT statements
• Enhancements to collections:
• Collection constructors that use arbitrary expression elements
• Collection-derived tables
• Collection subqueries

This manual describes the following performance improvements to Version 9.2 of Dynamic Server:

• SQL statement cache
• For UDRs:
• Expensive-function optimization
• Parallel UDRs

This manual describes the following special features in Version 9.2 of Dynamic Server:

• Long identifiers:
• 128-character identifier
• 32-character user names
• Ability to retain update locks