O'Reilly logo

Joe Celko's SQL for Smarties, 5th Edition by Joe Celko

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 38

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required