16.20 - SPL1136: "%s:E(L%d), WITH...BY clause cannot be specified in cursor select statement." - 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

SPL1136: "%s:E(L%d), WITH...BY clause cannot be specified in cursor select statement."

Explanation:

The cursor select statement should not contain any WITH...BY clause.

Generated By:

TSP module.

For Whom:

End user.

Remedy:

Remove the WITH.BY clause from the cursor select statement. Please correct and resubmit.