The primary resource for application programmers is the ALLBASE/SQL Application Programming Guide for your chosen programming language--C, COBOL, FORTRAN, or Pascal. In that guide you will find chapters like the following (there is some variation in contents, depending on your programming language):
"Getting Started with ALLBASE/SQL Programming," is an introduction to ALLBASE/SQL programming which includes information on developing, using, and maintaining programs.
"Using the Preprocessor," explains the ALLBASE/SQL preprocessor and how to invoke it.
"Host Variables," describes how to define and use variables to transfer data between your program and an ALLBASE/SQL DBEnvironment.
"Runtime Status Checking and the sqlca," defines ways to monitor and
handle successful and unsuccessful SQL statement execution.
"Simple Data Manipulation," explains how to operate on one row at a time.
"Processing with Cursors," shows how to process a multiple row query result one row at a time.
"BULK Table Processing," examines the processing of multiple rows at a time.
"Using Dynamic Operations," describes the use of ALLBASE/SQL statements that are preprocessed at runtime.
Other chapters present material on more specialized topics. The Application Programming Bulletin for the current release contains information about coding the latest enhancements to ALLBASE/SQL.
You should also use the ALLBASE/SQL Reference Manual for the complete syntax of all SQL statements. The ALLBASE/SQL Quick Reference Guide contains a convenient summary of information about data types and host variable declarations in all languages.
