Enterprise Edition Home | Express Edition Home | Previous Page | Next Page

SPL Statements

In This Chapter

Referencing TEXT and BYTE Variables

Redeclaration or Redefinition

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

Using the TO Keyword to Define a Range

Specifying Two or More Ranges in a Single FOR Statement

Using an Expression List as the Range

Mixing Range and Expression Lists in the Same FOR Statement

Using a SELECT ... INTO Statement

Using Hold Cursors

Updating or Deleting Rows Identified by Cursor Name

Using Collection Variables (IDS)

Modifying Elements in a Collection Variable

Conditions in an IF Statement

Subset of SPL Statements Allowed in the IF Statement List

SQL Statements Not Valid in an IF Statement

Using a SELECT Statement in a LET Statement

Calling a Function in a LET Statement

Placement of the ON EXCEPTION Statement

Continuing Execution After an Exception Occurs

RAISE EXCEPTION

Returning Values from Another Database (IDS)

External Functions and Iterator Functions (IDS)

Executing the SYSTEM Statement on UNIX

Executing the SYSTEM Statement on Windows

Setting Environment Variables in SYSTEM Commands

TRACE PROCEDURE

Displaying Expressions

Example Showing Different Forms of TRACE

Looking at the Traced Output

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]