Q&A BY TAG 'JDBC query'

You must sign in to ask a question. If you do not have an account, you can register here

QueryTimeout on DB2 Datasource Level
answered 25-05-2022 16:06:18 -0400

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://;databaseName=iqzdemo;queryTimeout=0; But for...

Answers: 1

JDBC query QueryTimeout

Getting Source Tables and Columns of a Datasource through Query
answered 17-11-2021 01:37:07 -0500

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

Answers: 5

JDBC query Database JDBC DataSource

Unable to Query views with individual columns in select query
answered 03-12-2020 06:51:36 -0500

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

Answers: 1


Retrieving Lineage of views
answered 22-10-2020 02:11:03 -0400

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.

Answers: 1

JDBC query data lineage #Data Lineage Lineage

How can we display the data of multi queries/views in multiple table formats using REST in VDP?
answered 13-08-2019 02:04:00 -0400

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

Answers: 1

JDBC query VDP Joining of Two Rest API DataSources Data

How do I pull all records from the past two days?
answered 23-05-2017 06:39:57 -0400

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)

Answers: 1

JDBC query QueryOptimization

Issue with fields with the new Denodo 6 version through JDBC
answered 14-04-2017 16:46:45 -0400

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

Answers: 6

JDBC query