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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center