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

Finding a folder in GET_VIEWS() with a partial name
answered 16-12-2021 08:04:05 -0500

Hi all, How do I find a view in a folder based on a partial name of the folder? For example: SELECT name FROM GET_VIEWS WHERE input_database_name = 'database' AND folder='/%derived%' Some of my databases have views stored in say: Derived Views ...

Answers: 1


GET_VIEWS() function
answered 10-10-2017 08:57:46 -0400

I am using DENODO VDP version 6.0 20170515. When I create a view based on the following query: SELECT * FROM GET_VIEWS() I am getting an error: com.denodo.vdb.vdbinterface.common.clientResult.VQLException: Listener refused the connection with the foll...

Answers: 2