Preprocessor2 can return program status and error information to applications in several possible ways.
The primary communication method for applications written to run in Teradata session mode has been the SQLCA structure .SQLCA is a data structure that contains a list of return codes and other status information about a completed DML statement.
SQLCA provides the following support to embedded SQL applications:
- Result reporting
- Warning condition reporting
- Support for DSNTIAR
Embedded SQL application programs can interrogate the fields of SQLCA for the return codes that indicate the results of having executed an embedded SQL statement.
Embedded SQL applications can also retrieve full diagnostic text by using a supplied routine (see PPRTEXT).
SQLCA cannot be used with stored procedures.