3
Basic Language Features

This chapter discusses basic SQLJ language features and constructs that you use in coding your application.

SQLJ statements always begin with a #sql token and can be broken into two main categories: 1) declarations, used for creating Java classes for iterators (similar to JDBC result sets) or connection contexts (designed to help you strongly type your connections according to the sets of SQL entities being used); and 2) executable statements, used to execute embedded SQL operations.

For more advanced topics, see Chapter 7, "Advanced Language Features".

This chapter discusses the following topics.

• Overview of SQLJ Declarations

• Overview of SQLJ Executable Statements

• Java Host Expressions, Context Expressions, and Result Expressions

• Single-Row Query Results--SELECT INTO Statements

• Multi-Row Query Results--SQLJ Iterators

• Assignment Statements (SET)

• Stored Procedure and Function Calls

---