Delimiting SQL in a Program


Delimiters are used to distinguish SQL calls from the rest of the program. 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 an SQL statement in a COBOL program:

 EXEC SQL    A SQL statement END-EXEC. 

NOTE

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




DB2 for z. OS Version 8 DBA Certification Guide
DB2 for z/OS Version 8 DBA Certification Guide
ISBN: 0131491202
EAN: 2147483647
Year: 2003
Pages: 175
Authors: Susan Lawson

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net