Hi Denodo team,
Could you please help me on creating temporary tables in VQL stored procedures with example if possible. **I am trying the save the below code but getting error saying**
***Error saving stored procedure: Syntax error: Exception parsing query near 'CREATE*'**
(Program_Code IN VARCHAR,Source_Date_From IN DATE,Source_Date_To IN DATE)
AS (
// Procedure variables
ProgramCode VARCHAR;SourceDateFrom DATE;SourceDateTo DATE;
)
BEGIN
// Procedure body
ProgramCode:=Program_Code;
SourceDateFrom:=Source_Date_From;
SourceDateTo:=Source_Date_To;
CREATE TEMPORARY TABLE TempReq_Rep AS
SELECT * from <base_view> left outer join <dervied view>
on <join fields> where
(
program_code in (Select Value from split (Program_Code,',') )
AND status IN ('A', 'O', 'P')
AND nstatus NOT IN('X')
AND (source_date >= SourceDateFrom AND source_date <= SourceDateTo)
);
END;
Your help is much appreciated
