Q&A

Hi, I am getting an error for a view : Error in select view conditions, function substringof not created. I am not able to find the view name from this error. How can I find it?

Hi Team, I am working as a Data engineer and doing the Data Mesh Layer development. I am trying to create a Remote table to optimize the perfomance of the view created. I am not able to create it from Denodo Design Studio as not allowing to add a nam...

Hello, I'm trying to connect to our MariaDB database in Denodo 7.0. As the MariaDB driver is not installed in our Denodo server, I tested using the MySQL5 Database adapter as a substitute, as suggested here: https://community.denodo.com/answers/quest...

Requests in Diagnostic monitoring tool are shown in active and even cancelling these is not making them inactive. Same way, trying to cancel queries from Query Monitor but nothing is happening. Please suggest.

Hello Denodo Community, I am creating a view on top of baseview which has username as one of the columns. When I add a filter on username column, it is showing as reserved word. How do I get around it?

Hi I have timestamps defined as decimals which I'm trying to convert to a date/time format to do a DaysBetween calculation --select getdaysbetween(to_date(date as decimal), to_date( '26-11-2021')) date as decimal = '20220225140000600' when I try t...

Hi, how can i run an update statement? I have views and then views built on top of those views, but i also need to run an update statement. How can i do that, does it need to be in a stored procedure? I am hoping that there is a way to run updates etc ...

How do I achieve the functionality to calculate a date -1 to show a day prior in denodo?

Hello Im looking to get going on Lab Create a JDBC data source and import tables graphically - DEN80EDU12D01LAB01 the first lab in the Connection to databases course. I've setup my Denodo Quickstart VM (DQVM) and its running on 192.168.100.3 and I ha...

I am using WEBCONTAINER_ELEMENT_STATUS() to retrieve information on the webservices showing the "deployed" status. Is this deployed=true enough to know if the webservice is accessible? Thank You. EA