Latest Activity


Denodo stored procedure with input parameters to execute vcs(dvcscommit) command:

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


Complex Iterative Queries using "Cursor" or "Loops"

Good morning Denodo Community, I'm trying to build a fairly complex query to calculate values based on a hierarchy. There are N number of nodes which need to generate a value. |-- Distri...

Do While Cursors Loops