SPL1071: "%s:E(L%d), Unexpected text CREATE/REPLACE keyword, Ignoring the text." - 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

SPL1071: "%s:E(L%d), Unexpected text CREATE/REPLACE keyword, Ignoring the text."

Explanation:

The CREATE/REPLACE keyword was encountered more than once. The user is trying to compile more than one SPL at a time.

Generated By:

TSP module.

For Whom:

End user.

Remedy:

The CREATE/REPLACE can occur only once in a stored procedure. Check whether you are trying to compile more than one Stored Procedure at a time. Correct and resubmit.