Introduction

Overview of SQL Syntax

SQL Statements

In This Chapter

ALLOCATE COLLECTION

ALLOCATE DESCRIPTOR

ALLOCATE ROW

ALTER ACCESS_METHOD

ALTER FRAGMENT

ALTER FUNCTION

ALTER INDEX

ALTER PROCEDURE

ALTER ROUTINE

ALTER SEQUENCE

ALTER TABLE

BEGIN WORK

CLOSE

CLOSE DATABASE

COMMIT WORK

CONNECT

CREATE ACCESS_METHOD

CREATE AGGREGATE

CREATE CAST

CREATE DATABASE

CREATE DISTINCT TYPE

CREATE DUPLICATE

CREATE EXTERNAL TABLE (XPS)

CREATE FUNCTION

CREATE FUNCTION FROM

CREATE INDEX

CREATE OPAQUE TYPE

CREATE OPCLASS

CREATE PROCEDURE

CREATE PROCEDURE FROM

CREATE ROLE

CREATE ROUTINE FROM

CREATE ROW TYPE

CREATE SCHEMA

CREATE SCRATCH TABLE

CREATE SEQUENCE

CREATE SYNONYM

CREATE TABLE

CREATE TEMP TABLE

CREATE Temporary TABLE

CREATE TRIGGER

Syntax

Usage

Defining a Trigger Event and Action

Restrictions on Triggers

Trigger Modes (IDS)

Trigger Inheritance in a Table Hierarchy (IDS)

Triggers and SPL Routines

Trigger Events

INSERT Events and DELETE Events

UPDATE Event

Defining Multiple Update Triggers

SELECT Event (IDS)

Circumstances When a Select Trigger is Activated

Stand-alone SELECT Statements

SELECT Statements Within UDRs in the Select List

UDRs That EXECUTE PROCEDURE and EXECUTE FUNCTION Call

Subqueries in the Select List

Select Triggers in Table Hierarchies

Circumstances When a Select Trigger is Not Activated

Action Clause

Guaranteeing Row-Order Independence

RERERENCING Clauses

Correlated Table Action

Triggered-Action List

Using Correlation Names in Triggered Actions

Re-Entrancy of Triggers

Rules for SPL Routines

Privileges to Execute Trigger Actions

Cascading Triggers

External Tables

Logging and Recovery

INSTEAD OF Triggers on Views (IDS)

CREATE VIEW

CREATE XADATASOURCE

CREATE XADATASOURCE TYPE

DATABASE

DEALLOCATE COLLECTION

DEALLOCATE DESCRIPTOR

DEALLOCATE ROW

DECLARE

DELETE

DESCRIBE

DESCRIBE INPUT

DISCONNECT

DROP ACCESS_METHOD

DROP AGGREGATE

DROP CAST

DROP DATABASE

DROP DUPLICATE

DROP FUNCTION

DROP INDEX

DROP OPCLASS

DROP PROCEDURE

DROP ROLE

DROP ROUTINE

DROP ROW TYPE

DROP SEQUENCE

DROP SYNONYM

DROP TABLE

DROP TRIGGER

DROP TYPE

DROP VIEW

DROP XADATASOURCE

DROP XADATASOURCE TYPE

EXECUTE

EXECUTE FUNCTION

EXECUTE IMMEDIATE

EXECUTE PROCEDURE

FETCH

FLUSH

FREE

GET DESCRIPTOR

GET DIAGNOSTICS

GRANT

GRANT FRAGMENT

INFO

INSERT

LOAD

LOCK TABLE

MERGE

MOVE TABLE

OPEN

OUTPUT

PREPARE

PUT

RENAME COLUMN

RENAME DATABASE

RENAME INDEX

RENAME SEQUENCE

RENAME TABLE

REVOKE

REVOKE FRAGMENT

ROLLBACK WORK

SAVE EXTERNAL DIRECTIVES

SELECT

SET ALL_MUTABLES

SET AUTOFREE

SET COLLATION

SET CONNECTION

SET CONSTRAINTS

SET Database Object Mode

SET DATASKIP

SET DEBUG FILE

SET Default Table Space

SET Default Table Type

SET DEFERRED_PREPARE

SET DESCRIPTOR

SET ENCRYPTION PASSWORD

SET ENVIRONMENT

SET EXPLAIN

SET INDEX

SET INDEXES

SET ISOLATION

SET LOCK MODE

SET LOG

SET OPTIMIZATION

SET PDQPRIORITY

SET PLOAD FILE

SET Residency

SET ROLE

SET SCHEDULE LEVEL

SET SESSION AUTHORIZATION

SET STATEMENT CACHE

SET TABLE

SET TRANSACTION

SET Transaction Mode

SET TRIGGERS

START VIOLATIONS TABLE

STOP VIOLATIONS TABLE

TRUNCATE (IDS)

TRUNCATE (XPS)

UNLOAD

UNLOCK TABLE

UPDATE

UPDATE STATISTICS

WHENEVER

SPL Statements

Data Types and Expressions

Other Syntax Segments

Appendix A. Reserved Words for IBM Informix Dynamic Server

Appendix B. Reserved Words for IBM Informix Extended Parallel Server

Appendix C. Accessibility

Notices

Index