Q&A

Preserving VQL formatting when using Edit Mode
answered 03-09-2021 19:53:00 -0400

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

Answers: 1

VQL formatting

CSV Export | DENODO 8.0
answered 03-09-2021 13:37:15 -0400

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

Answers: 1

Ten million row limitation on CLEAN_CACHE_DATABASE
answered 03-09-2021 13:26:42 -0400

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

Answers: 1

CLEAN_CACHE_DATABASE

Left outer join losing rows
answered 03-09-2021 06:54:45 -0400

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

Answers: 1

Denodo 8.0 left join

DB2 nested stored procedure on ibm I or as/400 generates the result set. But the view on denodo does not get the result.
answered 02-09-2021 19:21:29 -0400

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

Answers: 1

JDBC Scheduler Exporter: Delete table content:: Truncate or delete?
answered 02-09-2021 19:19:59 -0400

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

Answers: 1

Exporter section

Pagination issue which retrieving data from API
answered 02-09-2021 13:44:50 -0400

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

Answers: 1

REST API Pagination Denodo Pagination

Dynamic Query in JSON
answered 02-09-2021 07:11:26 -0400

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

Answers: 1

Dynamic JSON JSON Data Source Dynamic Datasources JSON Datasource

Network path location value to interpolcation variable?
answered 02-09-2021 02:14:03 -0400

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?

Answers: 3

Convert text to int
answered 01-09-2021 12:59:48 -0400

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

Answers: 3