15.10 - Program Status Information - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

prodname
Preprocessor2 for Embedded SQL
vrm_release
15.10
category
Programming Reference
featnum
B035-2446-035K

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

When precompiling applications under:

  • Teradata mode (by setting the TRANSACT option to BTET, COMMIT or 2PC), define a communications area using the INCLUDE SQLCA statement.
  • ANSI compatible 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.