search

EXXETA / sonar-esql-plugin

Sonar plugin to analyze ESQL-sourcecode of IBM Integration Bus projects
Apache License 2.0
35 stars 34 forks source link

Unable to parse ESQL file with Teradata external procedure name #113

Closed djshea closed 4 years ago

djshea commented 4 years ago

ESQL contains a Teradata external procedure definition, for example -

CREATE PROCEDURE MyProc(IN P1 CHAR, IN P2 CHAR) LANGUAGE DATABASE DYNAMIC RESULT SETS 1 EXTERNAL NAME "%.TDataProc";

The "%" character indicates the database schema will be supplied at run time, for example -

CALL MyProc(Param1, Param2, ReturnList[]) EXTERNAL SCHEMA TdataSchema01;

The ESQL plugin fails to parse the CREATE PROCEDURE statement, the line with the '%' character is highligthed.