Skip to Content

SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "and"

Hi,

I am getting below error for while creating Procedure

SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "and": line 10 col 31 (at pos 351)

Syntex is:

Create procedure ID581103.EMP_PAYROLL_COMM (IN VARDEPTID INTEGER, IN VARQUATER NVARCHAR (2)) language SQLSCRIPT AS

BEGIN

SELECT "DEPTID", "CITY", "QUARTER", "SALARY", CASE "DEPTID" WHEN 1 then "SALARY" * 0.20 WHEN 2 then "SALARY" * 0.30 WHEN 3 then "SALARY" * 0.50

END AS COMMISSION

FROM "ID581103"."EMPDTLS" WHERE "DEPTID" * ':VARDEPTID' and "QUARTER" * :VARQUATER;

END;

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers