Embedded SQL, CLI Dynamic SQL, and SQL/PSM
Abstract
The ANSI/ISO Standard SQL includes methods for embedding SQL in traditional programming languages like COBOL, C, FORTRAN, etc., as well as a traditional procedural programming language called PSM to use with SQL.
Keywords
Embedded SQL
CLI Dynamic SQL
SQL/PSM (SQL/Persistent Stored Modules)
SQL/CLI
ODBC
ADA language
SQLSTATE
SQLERROR
CONTINUE
EXIT
NOT FOUND
SQLCODE
SQLEXCEPTION
SQLWARNING
UNDO
HANDLER
Assignment statement
Conditional statement
LOOP statement
FOR-DO loop
CALL statement
CREATE PROCEDURE
CREATE FUNCTION
IN
OUT
INOUT
RETURN
CSV parameters
Originally, SQL stood for “Structured Query Language” to differentiate it from the IBM product SEQUEL (short for Structured English ...
Get Joe Celko's SQL for Smarties, 5th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
