DB2(R) Universal Database for OS/390 V7.1 Application Certification Guide (IBM DB2 Certification Guide Series)

Team-Fly    
 
DB2 Universal Database for OS/390 v7.1 Application Certification Guide

By Susan Lawson

Table of Contents
Chapter 5.  Using SQL in an Application Program
Delimiting SQL in a Program

In order to distinguish SQL calls from the rest of the program, delimiters are used. Although used in languages, the actual delimiters and methods differ considerably by language. For all languages using the standard precompiler, however, the methods are very similar. For example, use EXEC SQL and END-EXEC to delimit a SQL statement in a COBOL program:

EXEC SQL a SQL statement END-EXEC.

NOTE

For REXX, precede the statement with EXECSQL. If the statement is in a literal string, enclose it in single or double quotation marks.

Team-Fly    
Top
Related

Категории