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