Latest Activity

code

Preserving VQL formatting when using Edit Mode

I generally work in the VQL mode in the Virtual DataPort tool and wish to retain my formatting. I use the "CONTEXT('formatted' = 'yes')" clause regularly, but even with that, I've noticed the formatting gets reverted back to default (including view ali...

code

CSV Export | DENODO 8.0

I am trying to export the CSV from Scheduler . so whenever I export data it is padded with blank spaces after using repeat but it is surrounded by double quotes . I just want blank spaces after it . E.g . CSV_FILE.csv Stud_Id Stud_Name 12 ,Mr.Jon &l...

code

Ten million row limitation on CLEAN_CACHE_DATABASE

We are caching a large dataset ( 40 Million + roiws), however the CLEAN_CACHE_DATABASE stored procedure only clears 10 Million rows at a time - so I have to re-run the sp in order to properly clean the DB. How do I get around this limitation, so it wi...

code

Left outer join losing rows

Hi, I'm joining a bunch of derived views. The SQL has 3 INNER joins and 2 LEFT OUTER joins. The LEFT OUTER joins are losing rows. One of this LEFT OUTER join has a static filter condition (like Active = 'Yes'). None of these derived views have PKs def...

code

DB2 nested stored procedure on ibm I or as/400 generates the result set. But the view on denodo does not get the result.

i have nestwnested nested stored procedure. i.e. stored proc 1 - creating tables and populating the tables stored proc 2 - to call external rpgle program which popultes one of the tables created. stored proc 3 - to call the stored proc 1, thethen c...

code

JDBC Scheduler Exporter: Delete table content:: Truncate or delete?

In the exporter section (JDBC) of a scheduler job, there is an option to "Delete table content:". Does this use truncate or delete? I need to know what grants to set int he database (Oracle 19c).

code

Pagination issue which retrieving data from API

We are connecting to API via a GATEWAY where our request is passed though based on the URI. Example 1) We have a API https://abc.com/api/v1.1/ 2) We need to call the API via a gateway, So Denodo will call http://gateway.com/abc/api/v1.1/query/pagesiz...

code

Dynamic Query in JSON

Hi team, How to create a dynamic query for the specific field or multiple fields? Because, I think Dynamic query helps to filter the data in runtime and gets to filter the huge data and provide the result much faster than the usual one. So I need to ...

code

Network path location value to interpolcation variable?

Hi Team, How to provide the Network path location value to the interpoltion variable for excel data source? \folder1\subfodler1\filename.xlsx If i give this value as the value for the interpolation variable test conenction fails. Any suggestions?

code

Convert text to int

Hi Team, How to convert text to integer data type for this example: column has 11-12 digits. I tried cast to int and big int but its giving incorrect results.What is the recommended numeric data type to handle this big number? 19,330,000,000 19,855,0...