I am trying to connect to Denodo express server running on localhost on port 9999 using NPGSQL version 5.0.3.0. The exception is : "Exception while reading from stream" The exception stack is shown below. at Npgsql.NpgsqlReadBuffer.<<Ensure>g...
Answers:
1
Hi, When i create a data source from other vdb using database adapter DENODO virtual dataport 7.0 with driver denodo com.denodo.vdp.jdbc.Driver how i import descriptions from views? Thanks
Answers:
1
I did this configuration in my resource manger and didn't worked. for exemple, I intent to have maximum 5 queries per user and not maximum 5 queries running in the server. what's happening for my is: user 1: running 2 queries user 2: running 2 quer...
Answers:
1
Is there a simple way to write a VQL script that not only shows all of the views -- i.e. LIST VIEWS on [database] but also would show the view and the columns, and field type from that view... (as well as description if possible). We are trying to g...
Answers:
2
Analytic Functions (Window Functions) using denodo 8.0 i have added functions into datasource (oracle19c) using source_configuration still getting below error Error executing view: Function row_number is not executable Any possible ways to use Analyt...
Answers:
3
How can I implement a rule with Resource Manager in order to limit the concurrent queries by user. I believe 5 query by user is ok. Thanks.
Answers:
2
We need to generate formatted documents from data in our SQL database including images. A parameterized query is used to access the data set for each document to be created. Can the Denodo built-in XSLT transformations capabilities be sued for this pur...
Answers:
1
Hi Team, I have teradata storedprocedures which has update statment when i execute the restAPI by updating a record then the order of rows are getting changed example: before updation: ROW1 ROW2 ROW3 ROW4 After updation: ROW3 ROW1 ROW4 ROW2 etc like a...
Answers:
1
Hi, Settings of memory usage: Maximum query size: 200 MB swapping status: ON Max size in memory of each node: 50 MB Max size of blocks stored: 200 KB There is a view which is using more than the specified memory. We don't want to increase the memory ...
Answers:
1
Is there a way I can have the system, by defult, add "CONTEXT ('formatted' = 'yes')" to the end of a derived view when I use the VQL Shell to create views, instead of having to write it out at the end of every script?
Answers:
1