IBM Informix Guide to SQL: Syntax
Collapsed Introduction
Collapsed Overview of SQL Syntax
Expanded SQL Statements
In This Chapter
Collapsed ALLOCATE COLLECTION
Collapsed ALLOCATE DESCRIPTOR
ALLOCATE ROW
Collapsed ALTER ACCESS_METHOD
Collapsed ALTER FRAGMENT
Collapsed ALTER FUNCTION
Collapsed ALTER INDEX
ALTER PROCEDURE
Collapsed ALTER ROUTINE
Collapsed ALTER SEQUENCE
Collapsed ALTER TABLE
Collapsed BEGIN WORK
Collapsed CLOSE
CLOSE DATABASE
Collapsed COMMIT WORK
Collapsed CONNECT
CREATE ACCESS_METHOD
Collapsed CREATE AGGREGATE
Collapsed CREATE CAST
Collapsed CREATE DATABASE
Collapsed CREATE DISTINCT TYPE
Collapsed CREATE DUPLICATE
Collapsed CREATE EXTERNAL TABLE (XPS)
Collapsed CREATE FUNCTION
CREATE FUNCTION FROM
Collapsed CREATE INDEX
Collapsed CREATE OPAQUE TYPE
Collapsed CREATE OPCLASS
Collapsed CREATE PROCEDURE
Collapsed CREATE PROCEDURE FROM
CREATE ROLE
CREATE ROUTINE FROM
Collapsed CREATE ROW TYPE
CREATE SCHEMA
CREATE SCRATCH TABLE
Collapsed CREATE SEQUENCE
Collapsed CREATE SYNONYM
Expanded CREATE TABLE
Logging Options
Using NULL as a Default Value
Using a Literal as a Default Value
Using a Built-in Function as a Default Value
Restrictions on Using the Single-Column Constraint Format
Using the NOT NULL Constraint
Using the UNIQUE or DISTINCT Constraints
Differences Between a Unique Constraint and a Unique Index
Using the PRIMARY KEY Constraint
Restrictions on Referential Constraints
Default Values for the Referenced Column
Referential Relationships Within a Table
Locking Implications of Creating a Referential Constraint
Example That Uses the Single-Column Constraint Format
Using the ON DELETE CASCADE Option
Using a Search Condition
Restrictions When Using the Single-Column Constraint Format
Declaring a Constraint Name
Choosing a Constraint-Mode Option (IDS)
Restrictions with the Multiple-Column Constraint Format
Using the FOREIGN KEY Constraint
Examples of the Multiple-Column Constraint Format
Using the WITH CRCOLS Option (IDS)
Using the IN Clause
Using the WITH ROWIDS Option (IDS)
Fragmenting by ROUND ROBIN
Fragmenting by EXPRESSION
Fragmenting by HASH (XPS)
Fragmenting by HYBRID (XPS)
Range Definition
Range IN Clause
Using the REMAINDER Keyword
Restrictions
Examples
Alternative to Full Logging
Precedence and Default Behavior
Using Large-Object Data in Typed Tables
Using the UNDER Clause
Privileges on Tables
Default Index Creation Strategy for Constraints
System Catalog Information
CREATE TEMP TABLE
Collapsed CREATE Temporary TABLE
Collapsed CREATE TRIGGER
Collapsed CREATE VIEW
CREATE XADATASOURCE
CREATE XADATASOURCE TYPE
Collapsed DATABASE
DEALLOCATE COLLECTION
DEALLOCATE DESCRIPTOR
DEALLOCATE ROW
Collapsed DECLARE
Collapsed DELETE
Collapsed DESCRIBE
Collapsed DESCRIBE INPUT
Collapsed DISCONNECT
DROP ACCESS_METHOD
DROP AGGREGATE
DROP CAST
DROP DATABASE
DROP DUPLICATE
Collapsed DROP FUNCTION
Collapsed DROP INDEX
DROP OPCLASS
Collapsed DROP PROCEDURE
DROP ROLE
Collapsed DROP ROUTINE
Collapsed DROP ROW TYPE
DROP SEQUENCE
DROP SYNONYM
Collapsed DROP TABLE
DROP TRIGGER
DROP TYPE
DROP VIEW
DROP XADATASOURCE
DROP XADATASOURCE TYPE
Collapsed EXECUTE
Collapsed EXECUTE FUNCTION
Collapsed EXECUTE IMMEDIATE
Collapsed EXECUTE PROCEDURE
Collapsed FETCH
Collapsed FLUSH
FREE
Collapsed GET DESCRIPTOR
Collapsed GET DIAGNOSTICS
Collapsed GRANT
Collapsed GRANT FRAGMENT
INFO
Collapsed INSERT
Collapsed LOAD
Collapsed LOCK TABLE
Collapsed MERGE
Collapsed MOVE TABLE
Collapsed OPEN
Collapsed OUTPUT
Collapsed PREPARE
Collapsed PUT
RENAME COLUMN
RENAME DATABASE
RENAME INDEX
RENAME SEQUENCE
RENAME TABLE
Collapsed REVOKE
Collapsed REVOKE FRAGMENT
ROLLBACK WORK
Collapsed SAVE EXTERNAL DIRECTIVES
Collapsed SELECT
SET ALL_MUTABLES
Collapsed SET AUTOFREE
Collapsed SET COLLATION
Collapsed SET CONNECTION
SET CONSTRAINTS
Collapsed SET Database Object Mode
Collapsed SET DATASKIP
Collapsed SET DEBUG FILE
SET Default Table Space
SET Default Table Type
Collapsed SET DEFERRED_PREPARE
Collapsed SET DESCRIPTOR
Collapsed SET ENCRYPTION PASSWORD
Collapsed SET ENVIRONMENT
Collapsed SET EXPLAIN
SET INDEX
SET INDEXES
Collapsed SET ISOLATION
Collapsed SET LOCK MODE
SET LOG
Collapsed SET OPTIMIZATION
Collapsed SET PDQPRIORITY
SET PLOAD FILE
Collapsed SET Residency
Collapsed SET ROLE
SET SCHEDULE LEVEL
SET SESSION AUTHORIZATION
Collapsed SET STATEMENT CACHE
SET TABLE
Collapsed SET TRANSACTION
SET Transaction Mode
SET TRIGGERS
Collapsed START VIOLATIONS TABLE
Collapsed STOP VIOLATIONS TABLE
Collapsed TRUNCATE (IDS)
Collapsed TRUNCATE (XPS)
Collapsed UNLOAD
UNLOCK TABLE
Collapsed UPDATE
Collapsed UPDATE STATISTICS
Collapsed WHENEVER
Collapsed SPL Statements
Collapsed Data Types and Expressions
Collapsed Other Syntax Segments
Collapsed Appendix A. Reserved Words for IBM Informix Dynamic Server
Collapsed Appendix B. Reserved Words for IBM Informix Extended Parallel Server
Appendix C. Accessibility
Notices
Index