© Copyright IBM Corp. 2007. All rights reserved. 241
Chapter 9. SQL Language
The Structured Query Language (SQL) is the language most widely used to
model, create, and query the data in relational databases. And, there is an SQL
language standard committee that continues to refine and expand the SQL
standard. All relational database management system (RDBMS) vendors
support various levels of the SQL standard and proprietary enhancements.
IDS 11 enhances compliance with the SQL standard and enables easier
application development, integration, and maintenance.
In this chapter, we discuss those features, which include support for:
򐂰 Subqueries in the FROM clause
򐂰 Named parameter support for JDBC
򐂰 Multiple triggers for the same event
򐂰 Stored procedure language enhancements
򐂰 New data types for hierarchical data modeling and access methods for text
search and messaging:
–Node
Binary18
–Binaryvar
Built-in text search access method
Access to WebSphere® MQ
9
242 Informix Dynamic Server 11: Advanced Functionality for Modern Business
򐂰 Optimizer enhancements:
Index self-join
Support for directives in ANSI join queries
Statistics feedback in the explain file
򐂰 New last committed read isolation level for enhanced concurrency
򐂰 XML publishing functions
򐂰 Infrastructure improvements:
More about statistics, automatic statistics collection while creating the
index, sysdbopen(), sysdbclose())
Distributed query support for new datatypes
New functions
There is quite a bit of information, so let us get started.

Get Informix Dynamic Server 11: Advanced Functionality for Modern Business now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.