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

BOOLEAN and Other Built-In Opaque Data Types (IDS)

Character Data Types

Numeric Data Types

Large-Object Data Types

Time Data Types

Distinct Data Types

Opaque Data Types

ROW Data Types

Collection Data Types

DATETIME Field Qualifier

Expression

INTERVAL Field Qualifier

Literal Collection

Literal DATETIME

Literal INTERVAL

Literal Number

Literal Row

Quoted String

Relational Operator

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