2108679 - CREATE PROCEDURE with Common Table Expression (CTE) generates an error

Creating Transact-SQL stored procedure generates an error e.g:

Could not execute statement.
Syntax error near 'WITH' on line 4
SQLCODE=-131, ODBC 3 State="42000"
Line 1, column 1

SAP SQL Anywhere 16.0 ; SAP Sybase SQL Anywhere 12.0 ; Sybase SQL Anywhere 11.0

Sybase , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Visit SAP Support Portal's SAP Notes and KBA Search.