ADABAS D C/C++ 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

 

• Predefined Data Types

 

• Predefined Data Types

 

• DECIMAL

 

• VARCHAR

 

• Structures in Host Variables

 

• 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 SQL Statements

 

• Dynamic SQL Statements

 

• Dynamic SQL Statements without Parameters

 

• Dynamic SQL Statements with Parameters

 

• Dynamic SQL Statements with Descriptor

 

• ADABAS SQLDA Structure

 

• ADABAS SQLDA Structure

 

• Using the Descriptor

 

• Using the Descriptor

 

• Overview of the Sequences of SQL Statements

 

• Overview of the 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

 

• The ADABAS Trace Facility

 

• The Trace File

 

• Profiling

 

• ADABAS Precompiler Statements

 

• Include Statements

 

• Include Statements

 

• exec sql include sqlca

 

• 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

 

• ADABAS Macro Statement

 

• ADABAS 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: Syntax of the Declare Section

 

• Appendix 1: Syntax of the Declare Section

 

• Appendix 2

 

• Internal Return Codes of the Precompiler

 

• Return Codes of an ADABAS Application

 

• Return Codes of the CPC Call