Introduction

Overview of SQL Syntax

SQL Statements

SPL Statements

Data Types and Expressions

In This Chapter

Scope of Segment Descriptions

Use of Segment Descriptions

Collection Subquery

Condition

Data Type

DATETIME Field Qualifier

Expression

INTERVAL Field Qualifier

Literal Collection

Literal DATETIME

Literal INTERVAL

Literal Number

Literal Row

Quoted String

Relational Operator

Using Operator Functions in Place of Relational Operators

Collating Order for U.S. English Data

Support for ASCII Characters in Nondefault Code Sets (GLS)

Literal Numbers as Operands

Other Syntax Segments

Appendix A. Reserved Words for IBM Informix Dynamic Server

Appendix B. Reserved Words for IBM Informix Extended Parallel Server

Appendix C. Accessibility

Notices

Index