Latest Activity
I would like to setup the querytimeout on DB2 datasource connection string. I don't want to do it on server level. The below example for sqlserver , which is working jdbc:sqlserver://34.75.137.211:41200;databaseName=iqzdemo;queryTimeout=0; But for...
Hi Denodo team, Are there any queries to get all the tables in the datasource and also columns in a datasource for a specified table. I have seen that GET_SOURCE_TABLE() procedure is giving table but it takes view name as a parameter,but I don't want t...
Hi Denodo team, I am trying to query a view with its individual columns in the select query but it is failing to fetch the result and throwing the below error. Finished with error: Error in select view conditions: Field not found 'view_name.column_name...
Hi Denodo team, I want to retrieve lineage of a view and its columns through query. Like if give a view name to query it should fetch its relative views.In similar way for its columns.Please help me with this.
I want to display data in multiple table formats from different quries. Below is the format i needed in browser using REST api. Customer Name Customer Number Gogly 1456 Product Name Product ID HR 10 Payroll 11 But when i use, joins it is giving like ...
What is the best way to pull all records from the past two days? Here is what I currently have and it does not work: select * from table_1 where creation_date between CURRENT_DATE and Subtract(CURRENT_DATE(), 2)
We tackled a new error, after update to the last Denodo 6 version (from January 2017). we get an exception from : com.denodo.vdb.engine.wrapper.raw.jdbc.JDBCAccess [] - Error creating new metavalue the next line of the exception is : com.denodo.vdb.en...