SQL statements

This chapter describes the syntax and semantics of SQL statements that are recognized by Informix®.

The SQL statement names that appear as the title to each statement description in this chapter are listed in alphabetical order.

For some statements, important details of the semantics appear in other volumes of this documentation set, as indicated by cross-references.

For many statements, the syntax diagram, or the table of terms immediately following the diagram, or both, includes references to syntax segments in Data types and expressions or in Other syntax segments.

When the name of an SQL statement includes lowercase characters, such as ”SET Database Object Mode,” it means that the first mixed-lettercase string in the statement name is not an SQL keyword, but that two or more different SQL keywords can follow the preceding uppercase keyword.

For an explanation of the structure of statement descriptions, see Overview of SQL syntax.