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 the data structures that Adabas Native SQL builds in your programs, how your program should react if Adabas Native SQL detects an error, how Adabas Native SQL reads lists of records in sequence, how to hold records in order to avoid updating conflicts, and how to access and update files that are protected by the Adabas security mechanisms. 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.

Other Sources of Information

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.