-1006 WITH is an incorrect keyword for this statement - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 (SPP Prefix) Messages

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Preprocessor2 for Embedded SQL
Release Number
15.xx, 16.xx, 17.xx, 20.xx
Published
June 2020
Language
English (United States)
Last Update
2023-11-20
lifecycle
Latest
Product Category
Teradata Tools and Utilities

-1006 WITH is an incorrect keyword for this statement

Possible Cause

A WITH clause was used as part of a dynamic SELECT request. WITH may not be used for a SELECT request.

Possible Solution

Remove the WITH clause from the request.