SQLSTATE Variable - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide

Product
Teradata Preprocessor2
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
whb1544831946911.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2446
lifecycle
previous
Product Category
Teradata Tools and Utilities

The SQLSTATE and SQLCODE variables are documented in Teradata Vantage™ - 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.