You can translate the question and the replies:

VQL Querying Folder/Database/Table information through JDBC

is it possible that I VQL query from external application using JDBC to find Folder name which contains a given view/data source name? Also is it possible to VQL query from external application using JDBC to find the database name of a given data source and underlying table of a given table name?
JDBC VQL
user
19-01-2017 16:46:34 -0500
code

1 Answer

Hi, I use the below VQL command to find the folder name and database name which contains a given view/data source, CALL GET_ELEMENTS(null, 'bv_hr_countries', '*', null, null,null, null, null, null, null); The above VQL query helps me search for a view named "bv_hr_countries'" and lists all the databases and folders which contains this view. Here instead of a view name you could also provide a data source name to be filtered. The query displays the following information, 1.Database Name 2.Name 3.Type of the element 4.Sub type 5.User_creator 6.Last_user_modifier 7.create_date 8.Last_modification_date 9.Description 10.Folder Hope this helps you!
Denodo Team
25-01-2017 04:59:43 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here