16.20 - SPL1126: "%s:E(L%d), Illegal attempt to modify %s field in diagnostics area." - Teradata Vantage NewSQL Engine

Teradata® Vantage - Database Stored Procedure Compilation (SPL Prefix) Messages

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1096-162K

SPL1126: "%s:E(L%d), Illegal attempt to modify %s field in diagnostics area."

Explanation:

The user attempted to change the values of CONDITION_NUMBER, RETURNED_SQLSTATE, CONDITION_IDENTIFIER, or MESSAGE_LENGTH in a SIGNAL or RESIGNAL statement, which is not allowed. The user may also have attempted to modify CLASS_ORIGIN or SUBCLASS_ORIGIN in a SIGNAL or RESIGNAL statement when an SQLSTATE value is used or a condition name is used that has an associated SQLSTATE value. The %s contains any one of the above condition information items.

Generated By:

TSP module.

For Whom:

End user.

Remedy:

Correct the SIGNAL or RESIGNAL statement based on the field mentioned in the error message and resubmit the stored procedure for compilation.