IBM Informix Guide to SQL: Syntax
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
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
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