New Features in Dynamic Server, Version 10.00.xC3

3For a comprehensive list of new database server features 3in Version 10.00.xC3, see the IBM Informix Getting Started Guide. This 3section lists new features introduced in Version 10.00.xC3 that this manual 3describes.

3New data definition language (DDL) statements support XA-compliant 3external data sources. Use these to apply the transactional semantics of Dynamic 3Server and two-phase commit protocols to transactions with external data sources:

3
• CREATE XADATASOURCE
3
• CREATE XADATASOURCE TYPE
3
• DROP XADATASOURCE
3
• DROP XADATASOURCE TYPE

3New Projection Clause syntax of the SELECT statement can 3control the number of qualifying rows in the result set of a query:

3
• SKIP offset
3
• LIMIT max

The SKIP offset clause excludes the first offset qualifying rows from the result set, for offset an integer. If you also include the LIMIT max clause (where LIMIT is a keyword synonym for FIRST), no more than max rows are returned. The offset and max values can be specified as literal integers in the 3SERIAL8 range, or as host variables, or as local SPL variables. You can save 3the result set as a collection-derived table (CDT).

3If you also include the ORDER BY clause, qualifying rows 3are first arranged by the ORDER BY specification before SKIP offset and LIMIT max clauses are applied.