Introduction

Overview of SQL Syntax

SQL Statements

SPL Statements

In This Chapter

CALL

CASE

CONTINUE

DEFINE

EXIT

FOR

FOREACH

Using a SELECT ... INTO Statement

Using Hold Cursors

Updating or Deleting Rows Identified by Cursor Name

Using Collection Variables (IDS)

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