Using PPRTEXT to Retrieve Return Codes - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

Product
Preprocessor2 for Embedded SQL
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2446
lifecycle
previous
Product Category
Teradata Tools and Utilities

PP2 provides a mechanism for retrieving the CLIv2, TDP, PP2 runtime or Teradata Database return codes, and the message text associated with the SQLCODE.

When SQL Flagger warnings are found, only the first such warning for a particular statement is available through PPRTEXT.

The application issues a call to PPRTEXT, passing four parameters as input to the routine. For additional information on PPRTEXT, see Messages (B035‑1096).

The four parameters are defined in “SQL Error Return—Teradata Mode” on page 118, along with an example of how an application might call this routine.