Using PPRTEXT to Retrieve Return Codes - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Preprocessor2
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2023-11-20
dita:mapPath
nyr1691484085721.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
xfi1470440464166
Product Category
Teradata Tools and Utilities

PP2 provides a mechanism for retrieving the CLIv2, TDP, PP2 runtime, or database return codes; and the message text associated with 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 Teradata Vantage™ - Database Messages, B035-1096.

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