HP 3000 Manuals HP 3000 Manuals
Chapter 1 Getting Started with ALLBASE/SQL Programming in C ALLBASE/SQL is a relational database management system that uses SQL statements to access data within an ALLBASE/SQL DBEnvironment. Embedding SQL statements in your C program and preprocessing with the SQL preprocessor allows programmatic access to this data. Embedded statements are ALLBASE/SQL commands in the flow of what would otherwise be C source code. When embedded statements are present, the source code must be passed through an ALLBASE/SQL preprocessor to convert them to a form understood by the C compiler. This chapter examines the steps to follow as you begin to work with embedded SQL. It focuses on the programmer's tasks, which are presented in the following sections: * Understanding ALLBASE/SQL Operations. * Understanding the Program Life Cycle. * Developing ALLBASE/SQL Applications. * Moving Programs into Production. * Maintaining ALLBASE/SQL Applications. * Programming Under the MPE XL Operating System. * Looking at an Embedded SQL Source Program Embedded SQL programming is a simple process. You include SQL statements in a C source program, then you preprocess the code using the ALLBASE/SQL C preprocessor before compiling and linking. The preprocessor is fully described in Chapter 2, and the specific techniques of ALLBASE/SQL programming are presented in more detail in the succeeding chapters. Readers who are already familiar with the general process of embedded SQL programming should skip ahead to Chapter 2.