Introduction

Overview of SQL Syntax

In This Chapter

How to Enter SQL Statements

How to Enter SQL Comments

Categories of SQL Statements

Data Definition Language Statements

Data Manipulation Language Statements

Data Integrity Statements

Cursor Manipulation Statements

Dynamic Management Statements

Data Access Statements

Optimization Statements

Routine Definition Statements

Auxiliary Statements

Client/Server Connection Statements

Optical Subsystem Statements (IDS)

ANSI/ISO Compliance and Extensions

SQL Statements

SPL Statements

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