Latest Activity
Hihi, I’ve tried to implement a modular RBAC via stored procedures as shown in the code below. While the GRANT statements seem to work, the REVOKE statements on views do not. Could you please assist with this issue? Additionally, I would like to ext...
So you know how when you want to insert variable in python is f"{variable_name}" For denodo I am unable to do so for the execute statement in custom stored procedures For instance the execute statements below would not work. What is the proper way of ...
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
I created a view that tists the metagroups (roles) that have been imported into Denodo. I'd like to send an email to these metagroups whenever there is an expected outage (when upgrading), or when a Denodo restored to service when it unexpectedly goes ...
Hello, the username of the caller can be extracted via environment.getDatabaseProperty("CURRENT_USER"); Is there any similar way to get the credentials of the user. I would need them to call the Data Catalog via REST Requests. Thanks in advance
How can i achieve this.. I am having couple of tables T1 with column C1, C2, and C3 T2 with column D1, D2, and D3 I need to look into a table T1 based on where condition (where C1 = 'ABC') and check if column C3 having value. - If so i need to pick...
My custom stored procedure seems to be performing all the tasks but displays the results on the VDP administration tool failing with the below error from the vdp.log file: 6106888826 [Access(1692)-244-02.00-mojodb.customscorer810] ERROR 2021-08-11T13:...
I have denodo platform 8.0 running on EC2 installed using cloudformation template as per the installation guide by Denodo. I am trying to create a custom stored proc which has to read a license file (locally saved inside /opt/denodo/denodo-platform8.0/...
Logging Custom stored procedure ERROR_HANDLING Custom Functions License File Denodo Jar
We want to execute some refresh vql command and get back the response through jdbc connection. Is it possible to obtain the input parameters in the initalize() method like we do in the doCall() And how do we extract and return the response of said vql...
Related to: Executing VQL statements from a stored procedure
Hi I'm trying to create a new project in eclipse after installing the denodo4e software successfully, but its giving me an error saying wizard cannot be started. Please help me on this as my teams development activities are getting delayed because of...