SQLSTATE Variable - 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

The SQLSTATE variable is an ANSI standard, 5-character string value logically divided into a 2-character class and a 3-character subclass.

SQLSTATE is defined as a character variable:

char SQLSTATE[6];

SQLSTATE is defined as having six characters. The last character of the variable holds the null character '\0' for C string termination.

A SQLSTATE and a SQLCODE variable can be defined for the same compilation unit. Both contain valid result codes.

For details on the ANSI SQLSTATE variable, see Teradata Vantage™ - SQL Stored Procedures and Embedded SQL, B035-1148.