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

INCREMENT BY Option

RESTART WITH Option

MAXVALUE or NOMAXVALUE Option

MINVALUE or NOMINVALUE Option

CYCLE or NOCYCLE Option

CACHE or NOCACHE Option

ORDER or NOORDER Option

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

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