Programmer's Guide to File Handling
Table of Contents
Index
Chapter 24: Embedded SQL Using DB2
24.1 Supported DB2 Systems
24.2 Features of the Micro Focus Support
24.3 Installation
24.4 SQL in COBOL Programs
24.4.1 The EXEC SQL Statement
24.4.2 Host Variables
24.4.2.1 Host Variables Declared Using COBOL Syntax
24.4.2.1.1 Small Integer
24.4.2.1.2 Large Integer
24.4.2.1.3 Varying Length Character Strings
24.4.2.1.4 Fixed Length Character Strings
24.4.2.1.5 Decimal
24.4.2.1.6 Float
24.4.2.2 Host Variables Declared Using SQL Syntax
24.4.3 Compound SQL
24.4.4 User Defined Functions and Stored Procedures
24.4.4.1 User Defined Functions
24.4.4.2 Stored Procedures
24.5 Extensions to Embedded SQL Support
24.5.1 The INCLUDE Statement
24.5.2 The DECLARE TABLE Statement
24.5.3 Integer Host Variables
24.5.4 Undeclared Host Variables
24.5.5 Qualified Host Variables
24.5.6 Host Variable Groups and Indicator Arrays
24.5.7 The NOT Operator (¬)
24.5.8 SQL Communications Area
24.5.9 The Sqlinit and sqlini2 Modules
24.6 Compiling
24.6.1 The SQL Compiler Directive
24.7 Linking
24.7.1 Linking for the 16-bit COBOL System
24.7.2 Linking for 32-bit COBOL Systems
24.8 Binding
24.9 Sample Program
24.9.1 Error Codes