INFORMIX
Informix Guide to SQL: Syntax
Chapter 1: SQL Statements
Home Contents Index Master Index New Book

In This Chapter

This chapter provides comprehensive reference information about SQL statements and the SQL segments that recur in SQL statements. It is organized into the following sections:

  • "How to Enter SQL Statements" shows how to use the information in the statement descriptions to enter SQL statements correctly.
  • "How to Enter SQL Comments" shows how to enter comments for your SQL statements in DB-Access command files, SQL APIs, and stored procedures.
  • "Categories of SQL Statements" divides SQL statements into several functional categories and lists the statements within each category. Some examples of these categories are data definition statements, data manipulation statements, and data integrity statements.
  • "ANSI Compliance and Extensions" explains how the SQL statements in this manual comply with the ANSI SQL standard. This section provides a list of ANSI-compliant statements, a list of ANSI-compliant statements with Informix extensions, and a list of statements that are Informix extensions to the ANSI standard.
  • "Statements" gives comprehensive descriptions of SQL statements. The statements are listed in alphabetical order.
  • "Segments" gives comprehensive descriptions of SQL segments. The segments are listed in alphabetical order. SQL segments are language elements, such as table names and expressions, that occur in many SQL statements. Instead of describing each segment in each statement where it occurs, this chapter provides a comprehensive stand-alone description of each segment. Whenever a segment occurs within the syntax diagram for an SQL statement, the diagram points to the stand-alone description of the segment for further information.
The following table summarizes the sections of this chapter.

Section Starting Page Scope

"How to Enter SQL Statements"

1-8

This section shows how to use the statement descriptions to enter SQL statements correctly.

"How to Enter SQL Comments"

1-11

This section shows how to enter comments for SQL statements.

"Categories of SQL Statements"

1-14

This section lists SQL statements by functional category.

"ANSI Compliance and Extensions"

1-19

This section lists SQL statements by degree of ANSI compliance.

"Statements"

1-21

This section gives reference descriptions of all SQL statements.

"Segments"

1-825

This section gives reference descriptions of all SQL segments.




Informix Guide to SQL: Syntax, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.