Q&A

I see that GROUP_CONCAT is a replacement for LISTAGG, but we often use XMLAGG due to LISTAGG's limitation of 4000 bytes. Does GROUP_CONCAT have the same limitation as LISTAGG? If so, is there a function similar to XMLAGG that doesn't have this limitation?

Denodo Version: Denodo 8 Enterprise Plus and Virtual Data Port Server 8.0 20230301. We were trying to do use case on Global Security Policies. We have a base view created with SSN Number. We would like to "Mask" by applying Global Security Policies &a...

Hi team, i have a database namae as o_",!#TT:1 How to escape the special characters for the above mentioned database name while creation. Also let me know is it possible to have special characters in database name?

Is there any way to get the swagger docs in a single page so users can see all the possible end points available? I see you can get to the doc for a single api using https://host:port/swagger-ui/index.html?url=/server/IT_DB/test_ws/OpenAPIv3/openapi.json

Hi All, I can't figure out how to combin Date and Time Column into a single Column for Datetime Select create_date, create_time from Inv Thank you in advance.

Hello, Our Denodo APPLICATION SYSTEM Administrator (install, configuration, patching, backend expert, backups, restore) is not with us anymore. We only have VQL developers on-site, and a couple of persons have been granted 'admin rights' to keep 'Den...

Hello, I'm implementing several stored procedures that call each other and themselves. However, when I use "select" or "call" within the stored procedure, I get a syntax error. Does anyone know how to call a stored procedure inside another one? T...

Hi Team, I want to create a view with below query- select distinct 'H' as home, 'O' as office, a.id, a.address from tableA a left join tableB b on a.id=b.id But when I give this hardcoded values to newly added columns in a join view, at the executio...

Hi, Our team is trying to install Denodo Express 8.0 on VM, but we are getting below errors. Could someone please provide a solutions or have come across simialar issue? (Note: regardless of these errors during installation, Setup GUI says " installati...

I would like to show a blank when the value in a date field is showing "1900-01-01 00:00". Assistance is greatly appreciated.