ADABAS D COBOL Precompiler

Top Level

Ordering the Manual

 

• Instructions for the User

 

• Instructions for the User

 

• Embedding ADABAS Calls in an  Application Program

 

• Introduction

 

• General Rules

 

• Multi-DB Mode

 

• The DECLARE Section

 

• Host Variables

 

• Host Variables

 

• General Host Variable Conventions

 

• Structures in Host Variables

 

• Indicator Variables

 

• Indicator Variables

 

• Generating Host Variables

 

• Generating Host Variables

 

• Generating Column Names

 

• Generating Column Names

 

• Messages Returned via the SQLCA Structure

 

• Messages Returned via the SQLCA Structure

 

• The WHENEVER Statement

 

• The WHENEVER Statement

 

• Dynamic ADABAS Statements

 

• Dynamic ADABAS Statements

 

• Dynamic SQL Statements without Parameters

 

• Dynamic SQL Statements with Parameters

 

• Dynamic SQL Statements with Descriptor

 

• ADABAS SQLDA Structure

 

• ADABAS SQLDA Structure

 

• Address of a COBOL Variable

 

• Address of a COBOL Variable

 

• Using the Descriptor

 

• Using the Descriptor

 

• Overview of the Static Sequences of SQL Statements

 

• Overview of the Static Sequences of SQL Statements

 

• The Macro Mechanism

 

• The Macro Mechanism

 

• Programming Instructions

 

• Processing Sets and Single Rows

 

• General Instructions

 

• Users

 

• Transactions

 

• Locks

 

• Locks

 

• Instructions for the Locking

 

• Timeouts

 

• Timeouts

 

• Optimizing SQL Statements

 

• Optimizing SQL Statements

 

• Influence of the Search Condition

 

• Search Strategies

 

• Search Strategies

 

• Definition of Terms

 

• Conditions on Key Columns

 

• Conditions on Single-Column Indexed Columns

 

• Strategies with Conditions on Multiple-Column Indexed Columns

 

• Cost-Finding

 

• Conditions Combined by OR

 

• Postponing the Search to the FETCH Point in Time

 

• UPDATE

 

• UPDATE

 

• The EXPLAIN Statement

 

• The EXPLAIN Statement

 

• Joins

 

• Joins

 

• EXPLAIN Statements for Joins

 

• ORDERED SELECT Statements (single row processing)

 

• ORDERED SELECT Statements (single row processing)

 

• Instructions to Increase the Speed

 

• Instructions to Increase the Speed

 

• Additional EXPLAIN Information: Columns O, D, T, M

 

• Additional EXPLAIN Information: Columns O, D, T, M

 

• Summary of the Present Chapter

 

• Summary of the Present Chapter

 

• Compatibility with Other Database Systems

 

• ANSI

 

• ORACLE

 

• The ADABAS Precompiler

 

• The ADABAS Precompiler

 

• ADABAS Precompiler Functions

 

• ADABAS Precompiler Functions

 

• Translation of an ADABAS Application Program

 

• Precompiler Options

 

• User Specifications for a Precompiler Run

 

• Precompiler Output Files

 

• Functions of the ADABAS Runtime System

 

• Functions of the ADABAS Runtime System

 

• Runtime Options

 

• User Specifications for the Application

 

• Precompiler Debugging Aids

 

• Precompiler Debugging Aids

 

• Testing at Precompilation Time

 

• Trace Facility of the ADABAS Application

 

• The Trace File

 

• Profiling

 

• ADABAS Precompiler Statements

 

• INCLUDE Statements

 

• INCLUDE Statements

 

• EXEC SQL INCLUDE <filename

 

• DECLARE Statements

 

• DECLARE Statements

 

• EXEC SQL BEGIN DECLARE SECTION

 

• EXEC SQL END DECLARE SECTION

 

• WHENEVER Statements

 

• WHENEVER Statements

 

• EXEC SQL WHENEVER SQLWARNING

 

• EXEC SQL WHENEVER SQLERROR

 

• EXEC SQL WHENEVER SQLEXCEPTION

 

• EXEC SQL WHENEVER NOT FOUND

 

• EXEC SQL WHENEVER SQLBEGIN

 

• EXEC SQL WHENEVER SQLEND

 

• ADABAS Statement

 

• ADABAS Statement

 

• EXEC SQL [<n

 

• EXEC SQL [<n

 

• Macro Statement

 

• Macro Statement

 

• EXEC SQL SET MACRO %NNN \

 

• Dynamic SQL Statements

 

• Dynamic SQL Statements

 

• EXEC SQL [<n

 

• EXEC SQL [<n

 

• EXEC SQL [<n

 

• EXEC SQL [<n

 

• ADABAS Cursor Statements

 

• ADABAS Cursor Statements

 

• EXEC SQL [<n

 

• EXEC SQL [<n

 

• EXEC SQL [<n

 

• EXEC SQL [<n

 

• TRACE Statements

 

• TRACE Statements

 

• EXEC SQL SET TRACE ON

 

• EXEC SQL SET TRACE LONG

 

• EXEC SQL SET TRACE OFF

 

• EXEC SQL SET TRACE LINE

 

• ADABAS Database Statements

 

• ADABAS Database Statements

 

• EXEC SQL CONNECT

 

• EXEC SQL [<n

 

• EXEC SQL [<n

 

• Command Statements

 

• Command Statements

 

• EXEC COMMAND

 

• QUERY Commands

 

• QUERY Commands

 

• EXEC QUERY

 

• EXEC REPORT

 

• EXEC SQL PROC

 

• EXEC TOOL STOP

 

• Appendix 1

 

• Internal Return Codes of the Precompiler

 

• Return Codes of an ADABAS Application

 

• Return Codes of the COBPC Call