15.10 - Chapter 1 Introduction - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

Preprocessor2 for Embedded SQL
Programming Reference

Teradata Preprocessor2 for Embedded SQL (PP2) provides an easy‑to‑use method of accessing data stored in the Teradata Database. PP2 does this 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.

Review the next sections in this chapter for information on:

  • PP2 Processes
  • Using Static and Dynamic SQL
  • Upgrading PP2 and CLIv2
  • Supported Operating Systems and Host Programming Languages
  • PP2 Input
  • PP2 Output
  • Contents of PP2 Output Listing
  • Diagnostic Messages
  • Client Language Source Code
  • Server Failure and Recovery
  • Period Datatypes
  • Query Banding
  • LOB Support
  • User‑Defined Types
  • User‑Defined Methods
  • Finding Information