SPP4500 Error at line <line>, column <column>Statement INCLUDE SQLCA is invalid for ANSI environment. - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 (SPP Prefix) Messages

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Preprocessor2 for Embedded SQL
Release Number
15.xx, 16.xx, 17.xx, 20.xx
Published
June 2020
ft:locale
en-US
ft:lastEdition
2023-11-20
lifecycle
Latest
Product Category
Teradata Tools and Utilities

SPP4500 Error at line <line>, column <column>Statement INCLUDE SQLCA is invalid for ANSI environment.

Language:

C, COBOL, PL/I

Possible Cause:

The TRANSACT(ANSI) option is specified and the INCLUDE SQLCA statement has been defined.

Possible Solution:

Recode using an ANSI SQLCODE variable in place of INCLUDE SQLCA for ANSI applications. For Teradata applications, precompile with TRANSACT(BTET|COMMIT|2PC) option.