Resolution:
Description:
===========
What are the Database.Templates.* catalog functions and how to use them?

Environment:
===========
TIBCO BusinessEvents 3.0.1
All Operating Systems

Resolution:
===========
Database template functions are the catalog functions available under "RDBMS Functions -> Database -> Templates".
By default, these are not available in the Designer. You need to set the following property in the designer.tra under %TIBCO_HOME%\designer\5.x\bin

java.property.TIBCO.CEP.modules.function.catalog.database.templates=true

These provide a way for the user to define the queries (like select * from EMPLOYEE) in an external configuraiton XML file, which is called templates file. Each query in the template XML file will have a name or key specified so that they can be uniquely identified in the XML file. To perform database operations on the database concepts, you can pass in this XML file and the key (particular query to use) to the Database.Templates.templateQuery() or Database.Templates.templateDML() functions. See the Designer tooltip of these functions for more details. Also attached is a sample test project (DBTemplate.zip) for reference.

What are the Database.Templates.* catalog functions and how to use them?