Q&A BY TAG 'Custom stored procedure'

You must sign in to ask a question. If you do not have an account, you can register here

Custom Script
answered 29-09-2021 03:29:08 -0400

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...

Answers: 1

Custom stored procedure custom script Stored Procedure

Data shows as NULL for my Custom Stored Procedure output
answered 12-08-2021 16:22:10 -0400

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:...

Answers: 1

Custom stored procedure

Denodo doesn't recognize local file within stored procedure
answered 07-06-2021 05:08:11 -0400

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/...

Answers: 4

Logging Custom stored procedure ERROR_HANDLING Custom Functions License File Denodo Jar

How to obtain the input parameters of the custom stored procedure in the overridden initalize() method?
answered 28-04-2021 07:57:50 -0400

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...

Answers: 1
Related to: Executing VQL statements from a stored procedure

Custom stored procedure JDBC

Error while creating a project in Eclipse
answered 04-01-2021 06:29:09 -0500

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...

Answers: 1

Denodo stored procedure Custom stored procedure