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