Delimiting SQL in a Program

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