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

Stored Procedure Compilation (SPL Prefix) Messages

Product
Teradata Database
Release Number
16.10
Language
English (United States)
Last Update
2018-10-22
dita:id
B035-1096-SPL
lifecycle
archive
Product Category
Teradata® Database

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.