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

Restrictions on Specifying Characters in Quoted Strings

The DELIMIDENT Environment Variable

Newline Characters in Quoted Strings

Using Quotes in Strings

DATETIME and INTERVAL Values as Strings

LIKE and MATCHES in a Condition

Inserting Values as Quoted Strings

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