Program Status Information - 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

Each time a SQL statement is executed, it returns a code to communicate whether or not the statement executed successfully. Therefore, define an area to receive these codes.

When precompiling applications in:

  • Teradata mode (by setting the TRANSACT option to BTET, COMMIT or 2PC), define a communications area by using the INCLUDE SQLCA statement.
  • ANSI mode (by defining TRANSACT as ANSI), use the SQLCODE and SQLSTATE variables to receive feedback information.

Do not mix program status communication areas between Teradata and ANSI compatible modes.