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

The SQLSTATE and SQLCODE variables are documented in SQL Data Manipulation Language (B035‑1146).

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

SQLSTATE is defined as:

Definition: 01 SQLSTATE PIC X(5);

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