Latest Activity
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 Denodo Team, I have created a VQL Stored Procedure which runs SQL statement based on the user input ui (hard-coded here for testing.) (paramName IN VARCHAR) AS ( // Declare Variables ui VARCHAR; ) BEGIN ui := 1; # CASE Statem...
When i execute below stored procedure: (view_path IN VARCHAR, commit_message IN VARCHAR) AS ( param1 VARCHAR; param2 VARCHAR; ) BEGIN EXECUTE 'connect database poc'; EXECUTE 'dvcscommit ''@param1'' LOGMESSAGE ''@param2''' PARAMETERS ( param1, param2 )...
automate git Denodo stored procedure Custom stored procedure dvcscommit Cursors Denodo 8.0 VQL Stored Procedure Error dvcs automate vcs
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...
Hi, I am trying to create this stored procedure: ( nomeview IN VARCHAR) AS ( // Procedure variables v_name VARCHAR; database_name VARCHAR; Interface_name VARCHAR; CURSOR interfaces IS 'SELECT view_name FROM VIEW_DEPENDENCIES() WHERE view_database_name...
Hello Denodo, I'm having trouble creating a VQL stored procedure for user and role changes. Is it possible to do this, and if so, how can I achieve it? Thank you.
Running the latest 8.0 release, when I paste into a VQL Shell window this example from Denodo documentation (https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/developing_extensions/developing_stored_procedures/developing_vql_stored_pro...
Hi , I have created a VQL stored procedure in Denodo 8.0 to insert data into a table via simple loop but my last record is getting inserted twice.I tried below command which works in PL/SQL but it is not working and giving error - Exception parsing qu...