Finding Information - Preprocessor2 for Embedded SQL

Topic

Chapter or Appendix

Book

Session management

SQL Data Handling

SQL Fundamentals (B035‑1141)

Return codes

Statement responses

Introduction to Embedded SQL

SQL Data Definition, Control, and Manipulation

Host structures

Embedded SQL

SQL Stored Procedures and Embedded SQL (B035‑1148)

Host variables

Input host variables

Output host variables

SQL character strings as host variables

Multistatement requests with embedded SQL

SQL statements for miscellaneous embedded SQL activities

Note: PP2 does not support SELECT AND CONSUME within cursors.

Static Embedded SQL Statements

Dynamic SQL statement syntax

Dynamic Embedded SQL Statements

SQL statements for client‑server connectivity

Client‑Server Connectivity Statements

SQL statements for multisession programming

Multisession Asynchronous Programming with Embedded SQL

SQL statements for cursor declaration and manipulation

SQL Cursor Control and DML Statements

SQLSTATE variable

Result Code Variables

SQLCODE variable

ACTIVITY_COUNT variable

SQL Descriptor Area (SQLDA)

SQL Descriptor Area (SQLDA)

SQL Communications Area (SQLCA)

SQL Communications Area (SQLCA)