Using the Teradata Preprocessor2 for Embedded SQL Programmer Guide
This guide describes the key concepts of Teradata® Preprocessor2 for Embedded SQL (PP2) and provides instructions for using the features. PP2 provides an easy-to-use method of accessing data stored in the database.
PP2 provides an easy-to-use method of accessing data stored in the database by interpreting and expanding Teradata SQL statements that have been embedded in an application program. Interpretation of the statements allows the program to perform tasks supported by Teradata SQL, such as data retrieval. The application program is called an embedded SQL host program. The language in which the host program is written is called the host programming language. Therefore, the host program consists of Teradata SQL code that provides the database interface, plus the host programming language, which provides remaining instructions for application execution.
Why Would I Use this Content?
This guide will help the application programmers who must incorporate Teradata SQL statements into COBOL, C, or PL/I application programs to access data stored in the database.
How Do I Use this Content?
- Connecting to the Database and Invoking PP2
- Writing Embedded SQL Applications in C
- Writing Embedded SQL Applications in COBOL
- Writing Embedded SQL Applications in PL/I
How Do I Get Started?
If you are new to PP2 and want to get the most out of the guide, start by reviewing the topics in the Introduction section.
If you want to learn more about the PP2 features and functionalities, start from the Overview topic of each section.
References to Other Relevant Content
- For a more detailed description of the Vantage system components and their roles in processing input and output, see Teradata Vantage™ - Database Introduction, B035-1091.
- For the full list of supported platforms and product versions, see Teradata® Tools and Utilities Compatibility Matrix (B035-3119).