INFORMIX
Informix Guide to SQL: Syntax
Introduction
Home Contents Index Master Index New Book

Major Features

The following SQL features are new with Universal Server, Version 9.1.
ALLOCATE COLLECTION

DROP TYPE

ALLOCATE ROW

EXECUTE FUNCTION

CREATE CAST

SET AUTOFREE

CREATE DISTINCT TYPE

SET DEFERRED_PREPARE

CREATE FUNCTION

Argument

CREATE FUNCTION FROM

Collection Derived Table

CREATE OPAQUE TYPE

External Routine Reference

CREATE OPCLASS

Function Name

CREATE ROUTINE FROM

Literal Collection

CREATE ROW TYPE

Literal Row

DEALLOCATE COLLECTION

Quoted Pathname

DEALLOCATE ROW

Return Clause

DROP CAST

Routine Modifier

DROP FUNCTION

Routine Parameter List

DROP OPCLASS

Specific Name

DROP ROUTINE

Statement Block

DROP ROW TYPE

The following SQL features are enhanced for use with Universal Server, Version 9.1.
ALLOCATE DESCRIPTOR

FLUSH

ALTER FRAGMENT

FREE

ALTER INDEX

GET DESCRIPTOR

ALTER TABLE

GET DIAGNOSTICS

CREATE INDEX

GRANT

CREATE PROCEDURE

INFO

CREATE PROCEDURE FROM

INSERT

CREATE SCHEMA

OPEN

CREATE SYNONYM

PREPARE

CREATE TABLE

PUT

CREATE VIEW

REVOKE

DEALLOCATE DESCRIPTOR

SELECT

DECLARE

SET DESCRIPTOR

DELETE

SET EXPLAIN

DESCRIBE

UPDATE

DROP INDEX

UPDATE STATISTICS

DROP PROCEDURE

Condition

DROP TABLE

Data Type

EXECUTE

Expression

EXECUTE PROCEDURE

Procedure Name

FETCH

Quoted String

The Introduction to each Version 9.1 product manual contains a list of major features for that product. The Introduction to each manual in the Version 9.1 Informix Guide to SQL series contains a list of new SQL features.

Major features for Version 9.1 Informix products also appear in release notes.




Informix Guide to SQL: Syntax, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.