This document describes the functions provided by Adabas Native SQL, Software AG's language for accessing Adabas files from Ada, COBOL, FORTRAN and PL/I programs. SQL stands for Structured Query Language.This document also describes how to code the statements that provide these functions.
The document's intended audience is an Ada, COBOL, FORTRAN77 or PL/I programmer who is also acquainted with Adabas concepts and who wishes to develop applications using Adabas Native SQL.
This documentation consists of the following sections:
 |
Introduction | This describes the basic concepts of Adabas Native SQL. |
|
Programming Considerations |
This provides background information you should read before using Adabas Native SQL for the first time. This material will help you understand
This also includes a section on distributed data processing. |
|
Single and Multiple-Record Processing | This deals with considerations when operating in single or multiple-record processing mode. |
|
Overview of Statements | This provides an overview of the syntax used in Adabas Native SQL statements, together with a brief description of the statements themselves, grouped logically according to statement function. This chapter also describes in detail the clauses common to statements which retrieve data from the database. |
|
Adabas Native SQL Statements | This describes in detail all the statements in alphabetical order for easy reference. |
|
Using Adabas Native SQL Statements in TP Programs | This provides additional information on the facilities provided for writing teleprocessing (TP) application programs. |
|
Global Parameters | This describes global parameters which can be used to define processing options and adapt them to your particular requirements. |
|
Appendix A: Size Limitations | Lists the size limitations of Adabas Native SQL. |
|
Appendix B: Descriptions of the Files used in the Examples | Contains a description of the files used in the sample programs and the FORTRAN synonyms that must be used. |
|
Appendix C | Adabas Native SQL statements used in the examples. |
|
Appendix D | ADA Examples |
|
Appendix E | Example of ADA code generated by Adabas Native SQL. |
|
Appendix F | COBOL Examples |
|
Appendix G | Example of COBOL code generated by Adabas Native SQL. |
|
Appendix H | FORTRAN Examples |
|
Appendix I | Example of FORTRAN code generated by Adabas Native SQL. |
|
Appendix J | PL/I Examples |
|
Appendix K | Example of PL/I code generated by Adabas Native SQL. |
This reference guide, read in conjunction with the Adabas Introduction Manual, should provide all the information that you need when writing Adabas Native SQL application programs. However, when writing TP application programs or if the database is protected by the Adabas security features, you may need to refer to other sources, for example the database administrator (DBA) or the following literature:
Adabas Operations Manual
Adabas Utilities Manual
Adabas DBA Reference Manual
Adabas Command Reference Manual
Adabas Installation Manual
Adabas Messages and Codes.
