Teradata Database Message 7836 - 17.10 - 7836 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
The XSP %DBID.%TVMID submitted a request subsequent to receiving a trigger fail message.
If the SQL based XSP is invoked inside of a trigger statement and it submits an SQL statement that causes an error the error is returned to the XSP and the request is marked as aborted inside of a trigger. The only option for the XSP in that case is to set the return SQLSTATE from the XSP to an error condition. If the SQL based XSP fails to do that and submits another request the transaction will be aborted with this error.
Generated By
UDF Subsystem
For Whom
XSP Developer
Fix the SQL statement the XSP submits while in a trigger. In addition add code to return an error SQLSTATE and return from the the XSP or return without issuing another request and the original error message will be returned to the caller.