Expand description
EXEC SQL statements, typed: what each one sends, what it receives into, and the WHENEVER actions
in force where it stands in the listing. The text a backend runs is the statement with each
input host variable replaced by ? and any INTO list removed, in one canonical spelling.
Structs§
- Cursor
- A cursor as its DECLARE gives it: the query OPEN runs and the host variables OPEN sends, or the prepared statement it runs, whose inputs OPEN … USING sends.
- Cursors
- The cursors declared so far in a listing. The precompiler reads a cursor’s name against the DECLAREs before it, so a statement naming a cursor declared later, or never, is refused.
- HostVar
- A host variable and the indicator variable that follows it.
- Sql
- An EXEC SQL block’s typed statement, its place among the program’s EXEC SQL blocks in listing order (from 1), and the WHENEVER actions in force where it stands.
- Whenever
- The WHENEVER actions in force at a statement.
Enums§
- Action
- Change
Kind - Condition
- Names
- What DESCRIBE puts in each SQLNAME: USING NAMES, LABELS or ANY.
- Rows
- FOR n ROWS: absent, so a rowset FETCH asks for as many rows as the cursor’s last one did, or one; a constant; or a host variable.
- Statement
Functions§
- fingerprint
- A statement’s identity in a recording: 32-bit FNV-1a over its canonical text.
- parse
- The statement in
body, the text between EXEC SQL and END-EXEC.