16.20 - Example: Returning the SQLSTATE Result Code Value - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

Consider the following external stored procedure C function:

void xsp_getregion( VARCHAR_LATIN *region,
                    char           sqlstate[6])
{
     ...
}

You can use the sqlstate argument to return the SQLSTATE result code value.

For example, if the value of the region argument is not a valid value, you can set the value of the sqlstate argument to return a data exception:

strcpy(sqlstate, "U0005");

In a BTEQ session, the exception condition appears in the following format, where dbname is the name of the database of the external stored procedure:

*** Failure 7504 in UDF/XSP  dbname.xsp_getregion: SQLSTATE U0005: