Latest Activity
Hi, I need connect a database in vql stored procedure with variable. I try this: (vdb_name IN VARCHAR, prt OUT VARCHAR) AS ( -- IN vdb VARCHAR; -- OUT prt VARCHAR; ) BEGIN EXECUTE 'CONNECT DATABASE '':vdb'''; RETURN ROW (prt) VALUES (vdb); END ...
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 ...
I am creating a VQL stored procedure, but it is not rolling back when I catch an exception. I am following the example provided here: https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/developing_extensions/developing_stored_procedure...
Hi everyone, this is the SP that creates the view interface and it's intended to be created in the indicated database specified in the parameter. How can I do that? [quarta-feira 17:22] Diogo Goncalves - Passio Consulting CREATE OR REPLACE PROCEDURE c...
VQL stored procedures Denodo 8.0 VQL Stored Procedure Error VQL Stored procedure
Hi everyone. Simple question here. I want to create a VQL Stored Procedure that returns a Select Statement, how do I do it? I have searched through the Denodo documentation for this but haven't found any reference about it. Thanks in advance
Hi everyone, I have been trying to recreate a view using a stored procedure, like this: ( nomeview IN VARCHAR) AS ( // Procedure variables v_name VARCHAR; database_name VARCHAR; i_name VARCHAR; CURSOR interfaces IS 'SELECT view_name FROM VIEW_DEPENDE...
Denodo Platform 8.0t, Subscription: Enterprise, Administration Tool 8.0 20230301, VDP Server l 8.0 20230301 Windows 10 Enterprise DATA SOURCE :Microsoft SQL Server 2016 (SP3-GDR) (KB5021129) - 13.0.6430.49 (X64) Jan 22 2023 17:38:22 Copyright (c) Micr...