Latest Activity

code

How to search for / list in Denodo columns (of a view) that make use of a certain function?

How can I search for / list in Denodo all columns (of a view) that make us of a certain function? For example, I would like to list all columns that make use of "getdaysbetween"?

Denodo stored procedure Metadata Catalog

code

Error while retrieving data from element_metadata() procedure

Need to extract data from element_metadata() procedure. I'm getting below error while executing this procedure. __P__S_NULL_79531090828947838643116096234859310357981553095826998064586988454878675543788_2743334557 [PROJECTION] [ERROR] ELEMENT_METADAT...

Metadata element_metadata

code

Can I store Denodo Metadata information in my own SQL Server database ?

Team, Can I store Denodo Metadata information in my own SQL Server database rather than default Apache Derby database ? If Yes, what is the process to do the same. We use Denodo Version 7. Thank you, Dilip

Metadata

code

Can I store Denodo Metadata information in my own SQL Server ?

Team, Can I store Denodo Metadata information in my own SQL Server database rather than default Apache Derby database ? If Yes, what is the process to do the same. We use Denodo Version 7. Thank you, Dilip

Metadata

code

Finding a list of views within a folder from metadata

How do I query Denodo metadata to return all of the views within a specific folder (or it's subfolders) within a database? I can select list of folders using "select resultname from catalog_elements() where resulttype='folder' " but I can't work out ...

Metadata

code

Metadata select invalid view/colums

Is it possible in denodo 6 tot make a query on metadta to select all invalid view with invalid columns?

Metadata

code

View column order metadata

I am using Denodo 7, latest update. I'm using get_view_columns() to extract metadata on columns included in views for various purposes. There doesn't seem to be anything that provides the order of the columns in the views. Is this metadata available a...

metadata column order get_view_columns

code

Query Denodo and return Rest Webservices Metadata

Is it possible to query Denodo 6.0 for rest webservice metadata (soap and json)? I found GET_CATALOG_METADATA_WS() in Denodo 7.0 manuals, but cannot find anything similar in 6. Thank you, John

Denodo 6.0 Metadata Rest Webservices

code

error accessing metadata

Hi Team, Denodo 5.5 DB1 - elevation in progress DB2 - query - select * from catalog_elements() DB2 - error - received exception with message 'error accessing the metadata while loading/storing objects' Is this error intended ? Please tell. Thanks.

metadata

code

Join conditions in metadata tables

Is there a metadata table which holds join condition and WHERE clause criteria of join views ? Plese let me know. Regards Nagaraja

joins in Metadata Metadata