Return
-
Title
'SQL Syntax Error' when running scripts in the editor on SAP HANA database -
Description
Toad Data Point shows the error message 'SQL Syntax Error' when trying to run SQL with scripting on an SAP HANA database. (SAP Hana server version 1.0.122.14.)
Example:DO BEGIN
declare variable nvarchar(30);
variable:='test';
select :variable as test from dummy;
END;
A similar issue with SUBST_REGEXPR also occurs but runs fine natively.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.