This stored procedure is deprecated and it may be removed in the next major version
of the Denodo Platform. Use the procedure GET_ELEMENTS instead of this one because “GET_ELEMENTS” can search on any database, not just in the one you are connected to and it returns the same information.

Description

The stored procedure CATALOG_ELEMENTS returns a list of the elements
(data sources, views, Web services, etc.) of the Virtual DataPort
database you are connected to. You can filter the result by several
parameters: element name, type, etc.

If invoke this procedure with CALL and you do not want to filter by a parameter, pass NULL to it.

When filtering by name, usercreator and/or
description, the comparison is performed with the contains
operator. E.g.: if usercreator is adm, the procedure
will return all the elements which creator contains the string
adm.

When providing a value for initcreatedate and
endcreatedate, or initlastmodificationdate
and endlastmodificationdate, the procedure returns the
elements between these two intervals. I.e.: when you provide a value
for initcreatedate and endcreatedate, the procedure
returns the elements created during these two dates.

If initcreatedate is null, the procedure returns all the
elements that were created before endcreatedate.

If endcreatedate is null, the procedure returns all the
elements that were created after initcreatedate.
Searching by initlastmodificationdate and
endlastmodificationdate works in the same way.