Introduction

Overview of SQL Syntax

SQL Statements

SPL Statements

In This Chapter

CALL

CASE

CONTINUE

DEFINE

Referencing TEXT and BYTE Variables

Redeclaration or Redefinition

Default Value

CURRENT

USER

TODAY

BYTE and TEXT

SITENAME or DBSERVERNAME

Subset of Complex Data Types (IDS)

Declaring Collection Variables (IDS)

Declaring ROW Variables (IDS)

Declaring Opaque-Type Variables (IDS)

Declaring Variables LIKE Columns

Declaring Variables as the PROCEDURE Type

Declaring Variables for BYTE and TEXT Data

EXIT

FOR

FOREACH

IF

LET

ON EXCEPTION

RAISE EXCEPTION

RETURN

SYSTEM

TRACE

WHILE

Data Types and Expressions

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