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 (which can be used to establish database connections to different kinds of schemas); 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

---