Informix Guide to SQL: Syntax
Chapter 1: SQL Statements
Home
Contents
Index
Master Index
New Book
ANSI Compliance and Extensions
The following lists show statements that are compliant with the
ANSI SQL
-92 standard at the entry level, statements that are
ANSI
compliant but include Informix extensions, and statements that are Informix extensions to the
ANSI
standard.
ANSI-Compliant Statements
CLOSE
COMMIT WORK
ROLLBACK WORK
SET SESSION AUTHORIZATION
SET TRANSACTION
ANSI-Compliant Statements with Informix Extensions
CREATE SCHEMA
CREATE TABLE
CREATE VIEW
DECLARE
DELETE
EXECUTE
FETCH
GRANT
INSERT
OPEN
SELECT
SET CONNECTION
UPDATE
WHENEVER
Statements That Are Extensions to the ANSI Standard
ALLOCATE COLLECTION
ALLOCATE DESCRIPTOR
ALLOCATE ROW
ALTER FRAGMENT
ALTER INDEX
ALTER TABLE
BEGIN WORK
CLOSE DATABASE
CONNECT
CREATE CAST
CREATE DATABASE
CREATE DISTINCT TYPE
CREATE FUNCTION
CREATE FUNCTION FROM
CREATE INDEX
CREATE OPAQUE TYPE
CREATE OPCLASS
CREATE PROCEDURE
CREATE PROCEDURE FROM
CREATE ROLE
CREATE ROUTINE
CREATE ROUTINE FROM
CREATE ROW TYPE
CREATE SYNONYM
CREATE TRIGGER
DATABASE
DEALLOCATE COLLECTION
DEALLOCATE DESCRIPTOR
DEALLOCATE ROW
DESCRIBE
DISCONNECT
DROP CAST
DROP DATABASE
DROP FUNCTION
DROP INDEX
DROP OPCLASS
DROP PROCEDURE
DROP ROLE
DROP ROW TYPE
DROP SYNONYM
DROP TABLE
DROP TRIGGER
DROP TYPE
DROP VIEW
EXECUTE FUNCTION
EXECUTE IMMEDIATE
EXECUTE PROCEDURE
FLUSH
FREE
GET DESCRIPTOR
GET DIAGNOSTICS
GRANT FRAGMENT
INFO
LOAD
LOCK TABLE
OUTPUT
PREPARE
PUT
RENAME COLUMN
RENAME DATABASE
RENAME TABLE
REVOKE
REVOKE FRAGMENT
SET
SET DATASKIP
SET DEBUG FILE TO
SET DESCRIPTOR
SET EXPLAIN
SET ISOLATION
SET LOCK MODE
SET LOG
SET OPTIMIZATION
SET PDQPRIORITY
SET ROLE
START VIOLATIONS TABLE
STOP VIOLATIONS TABLE
UNLOAD
UNLOCK TABLE
UPDATE STATISTICS
Informix Guide to SQL: Syntax
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.
