Categories of SQL Statements

Informix Guide to SQL: Syntax
Overview of SQL Syntax

Categories of SQL Statements

SQL statements are divided into the following categories:

Data definition statements

Data manipulation statements

Cursor manipulation statements

Cursor optimization statements

Dynamic management statements

Data access statements

Data integrity statements

Optimization statements

Routine Definition statements

Auxiliary statements

Client/server connection statements

Optical subsystem statements

The specific statements for each category are as follows.

Data Definition Statements

Data Manipulation Statements

Cursor Manipulation Statements

Cursor Optimization Statements

Dynamic Management Statements

Data Access Statements

Data Integrity Statements

Optimization Statements

Routine Definition Statements

Auxiliary Statements

Client/Server Connection Statements

Optical Subsystem Statements

Important: Optical Subsystem statements are described in the "Guide to the Optical Subsystem."

Informix Guide to SQL: Syntax, Version 9.2
Copyright © 1999, Informix Software, Inc. All rights reserved