Q&A

Pagination related question
answered 29-09-2020 15:02:12 -0400

I am calling an external API to Denodo which is a JSOn. That API has set default 1000 records which I received as it is in denodo. I was unable to fectch more record in denodo with that API so I thought of Pagination in JSOn DS> configure > Pag...

Answers: 1

Perform a join and only keep the first row
answered 29-09-2020 08:09:21 -0400

Perform a join and only keep the first row when the join condition it met

Answers: 1

How to remove leading zero's in date time stamp
answered 29-09-2020 05:57:13 -0400

I have below string output using Formatdate function applied 08/03/2017 04:48:34 PM How to remove leading zeros O/p - 8/3/2017 4:46:34 PM Please help

Answers: 1

Date time function

Convert rows into columns after flattening in denodo
answered 29-09-2020 02:05:34 -0400

I have created a base view out of an API which returns me some array rcolumns. I then flattened these columns using flattening function in denodo. But I get multiple rows for a single account. My requirement is to convert these rows in corresponding co...

Answers: 1

db2 LUW drivers
answered 29-09-2020 00:11:33 -0400

I need to configure a jdbc connecton to a db2 instance. I have been told that the version of db2 is V 10.5 Fix pack 7 . this look painful as teh denodo site sends me to https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.swg.im.dbclien...

Answers: 3

db2 drivers

RegexExp to extract value between parentheses
answered 28-09-2020 02:55:22 -0400

I am trying to use the following formula to return the value that is between parentheses in a field. For some reason it is just returning the exact same value. I am pretty sure this REGEX is valid. regexp(bv_epic_tpi_inventory_report.hcco, '/(([^)]+)...

Answers: 1

Formula Regex

Create view from json file
answered 25-09-2020 06:32:34 -0400

Hi Team, I need to create a view from multiple json files and luckly I have created view from them.Now challenge is like I have a view of coloumn which has itslef a colllection of elements means there are few columns in view which are itself an array ...

Answers: 1

OData 4 Custom Wrapper
answered 25-09-2020 04:36:30 -0400

Hello! I am tring to create a new datasource with the custom odata4 wrapper. It is showing in the Jars, but does not give me the option to refresh the input paramters. It seems like that button does not exist for me. When I try to save the datasource, ...

Answers: 1

VQL for updating the Base View
answered 24-09-2020 06:38:12 -0400

Hi, I know we can detect the changes in the underlying data source using GET_SOURCE_CHANGES and GET_VIEWS stored procedures. However, once we detect the changes, is there any way to refresh the base view (VQL commands?) once we detect the changes?

Answers: 3

Base view

Can we build/deletion DV objects in VDP through access the RestFul API?
answered 24-09-2020 06:34:23 -0400

Hi team, Do we have ways to created DV base views, derived views, delete existing views in VDP side through access REST API?

Answers: 3

VDP build views RestFul API