Q&A

Error Handling with Custom Functions
answered 23-09-2020 08:46:44 -0400

Is there a mechanism by which a custom function can report an error? It appears that exceptions thrown are swallowed and it is treated as though the function returns null.

Answers: 6

Function ERROR_HANDLING Custom Functions Error Handling

Can I feed Rest API parameters from a database query?
answered 23-09-2020 08:01:21 -0400

I have a list of ID values in a database table that I want to feed in as parameters to a Rest API call. I need to make one API call per ID value in the database table. I need to make the union of these Rest API calls into a single table. Can this be ...

Answers: 1

REST API

Flattening json content blob to separate columns
answered 22-09-2020 23:42:18 -0400

Hi, I am working with certain base views containing json data blobs as a column with the field type as text and not something like arrays.I am looking to flatten the view and get all the keys/values in separate columns. The content json blob column is ...

Answers: 1

json

Disadvantage of using multiple CTEs in Denodo
answered 22-09-2020 17:48:01 -0400

We are using many level of CTEs in our architeture.Also joining them with other integrated views.Please let me know what are the disadvantages of using CTEs in Denodo considering performance side.

Answers: 1

CTE

Error modifying view: View names not available
answered 22-09-2020 08:29:57 -0400

Hi , I am creating simple derived view from 2 base views , while enabling cache on the derived view i'm getting "Error modifying view: View names not available" error . Thanks for your help in advance....!

Answers: 1

Cache Error

Connecting to SSL Enabled Denodo Using NodeJS and JDBC
answered 22-09-2020 08:25:15 -0400

I am trying to connect to Denodo to obtain access to a view using a web app created from Node JS and the jdbc library. I was able to figure out how to successfully connect to a non SSL version of Denodo but I would like to know how to do it for an SSL ...

Answers: 4

JDBC Connectivity nodejs SSL

Connecting to an InterSystems Cache database
answered 22-09-2020 08:01:33 -0400

I am using Denodo 7.0 (20200310) and have a Cache database. until recently, an ODBC driver worked. it no longer functions. The recommended solution is to use an ODBC driver. At this point, I use the Generic database adapter and point to the jdbc driver...

Answers: 1

Denodo Installation Help
answered 22-09-2020 07:55:37 -0400

Hi All, I am new to Denodo. Could you please help me by providing a document of Denodo 7.0 & solustion Manager installation on the Linux server. Thank You, Ashif

Answers: 1

Denodo Installation

Unable to complete tutorial after moving to Denodo 8
answered 21-09-2020 16:28:57 -0400

Hi! Although it worked great with Denodo 7, with the new version I can't complete this simple tutorial scenario https://community.denodo.com/tutorials/browse/basics/2fs5jdbc I order to import the source I need JDBC driver installed as mentioned int the...

Answers: 2

Denodo 8.0 Tutorial

db2 issues
answered 21-09-2020 12:22:58 -0400

I have made progress on setting up a denodo connection to an LUW db2 10.5 database. I deployed a db2.10.5 driver v10.5fp11_linuxx64_dsdriver.tar (which I downloaded from IBM site) to denodo vdp external library. I configured my connection to db2 and I ...

Answers: 4

jdbcerrors db2drivers DB2 LUW