Q&A BY TAG 'denodo 6.0'

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

Denodo Scheduler services
answered 15-11-2016 03:08:51 -0500

Hi, I am unable to start scheduler services from services.msc, but in control center scheduler server seem to be running. When i checked scheduler log i saw "Scheduler Server: server could not be started: Another instance of Derby may have already boot...

Answers: 1

denodo 6.0 scheduler scheduler log

Forcing scheduled extracts to enclose all values in double quotes.
answered 09-11-2016 12:50:28 -0500

I am looking to provide a like for like file extract as a proof of concept, and the extract the users currently have enclose all the column values in double quotes. When I extract as csv using the scheduler (using denodo express 6.0), only values wher...

Answers: 1

scheduler denodo 6.0 denodo express csv formatting

Metadata stored procedures?
answered 09-11-2016 07:19:40 -0500

Hi Team, I do see list of metadata stored procedures mentioned in the documentation. But I strongly feel they are all on inclusive. Can you please here provide list or provide information where can we find all list of metadata stored procedure (ex...

Answers: 1

Denodo 6.0

Metadata query to check if all listed views are having stats or not?
answered 09-11-2016 07:17:41 -0500

Hi Team, Is there any way using metadata stored procedure we can check what all views are generated with statistics? Not sure on it so currently we are manually checking in individual view. Your provided information will save our lots of time. Thanks,

Answers: 3

Denodo 6.0

Windows OS: Export database using scheduler at Local machine folder using provided export.bat script
answered 03-11-2016 23:24:51 -0400

https://community.denodo.com/answers/question/details?questionId=90670000000blZWAAY&title=How+can+we+schedule+EXPORT+of+particular+database+or+folder%3F I have asked above question long back and tried fewer time refering to documentation but I thi...

Answers: 1

Denodo 6.0

Size of source table is not propagated to derived views
answered 02-11-2016 17:49:33 -0400

Hi Team, I can see there are many of our derived views are not showing up size. This makes them of inifinit length. This makes us violating coding standard. But it is annoying to set manually each and every one attributes size. We are using Oracle as...

Answers: 2

Denodo 6.0

How to fetch Current Date Records from a table
answered 25-10-2016 07:27:32 -0400

Team, We are using Denodo as Database. I have a table and I should not hard code the current date. I tried using currentdate, sysdate and the SQL is throwing error. Please help me on this! select * from EMP where EMPdate='2016-10-24' Thanks! Kiran

Answers: 1

denodo 6.0 SQL Server

Database migration issues in Denodo 6 --invalid identifier in query
answered 03-10-2016 18:42:51 -0400

Hello, We are doing code migration from denodo 5.5 to denodo 6.0. During testing the databases in denodo 6, we are facing below issues. Same queries are running fine in denodo 5.5. Issue1: ORA-00904: "T0"."FUNDCODE": invalid identifier Query execute...

Answers: 3

denodo 6.0

migration issue in denodo 6
answered 26-09-2016 09:24:38 -0400

Hi team , when i am tring to migrate code from denodo 5.5 to denodo 6.0. TO_DATE("yyyy-MM-dd",'2016-11-23') valid in denodo 5.5 but invalid in denodo 6.0 Error in select view conditions: Field not found 'yyyy-MM-dd' in view with schema how we can do...

Answers: 1

denodo 6.0

How can we apply INITCAP in Denodo? Do not see any function like that.
answered 15-09-2016 08:27:53 -0400

Hi Team, i wish to know how can we apply INITCAP functionality in Denodo. Say for example, If name of person should start with capital letter. 'John', 'Maria' etc I have checked documents but not able to see any functions related to it. if not foun...

Answers: 2

denodo 6.0