Introduction

Overview of SQL Syntax

SQL Statements

SPL Statements

Data Types and Expressions

Other Syntax Segments

In This Chapter

Arguments

Collection-Derived Table

Database Name

Database Object Name

External Routine Reference

Identifier

Use of Uppercase Characters

Use of Keywords as Identifiers

Support for Non-ASCII Characters in Identifiers

Delimited Identifiers

Potential Ambiguities and Syntax Errors

Using the Names of Built-In Functions as Column Names

Using Keywords as Column Names

Using ALL, DISTINCT, or UNIQUE as a Column Name

Using INTERVAL or DATETIME as a Column Name

Using rowid as a Column Name (IDS)

Workarounds that Use the Keyword AS

Using AS with Column Labels

Using AS with Table Aliases

Fetching Cursors that have Keywords as Names

Fetching Cursors that have Keywords as Names

Using CURRENT, DATETIME, INTERVAL, and NULL in INSERT

Using NULL and SELECT in a Condition

Using ON, OFF, or PROCEDURE with TRACE

Using GLOBAL as the Name of a Variable

Using EXECUTE, SELECT, or WITH as Cursor Names

SELECT Statements in WHILE and FOR Statements

SET Keyword in the ON EXCEPTION Statement

Related Information

Jar Name

Optimizer Directives

Owner Name

Purpose Options

Return Clause

Routine Modifier

Routine Parameter List

Shared-Object Filename

Specific Name

Statement Block

Appendix A. Reserved Words for IBM Informix Dynamic Server

Appendix B. Reserved Words for IBM Informix Extended Parallel Server

Appendix C. Accessibility

Notices

Index