DataBaseFunctions.conf

The custom reporting feature of IVIG allows you to use database functions when designing custom report templates.

This file is in the IM_HOME/data directory.

You can use the database functions with the Report Designer component of IBM Verify Identity Governance by defining the functions in the DataBaseFunctions.conf file.

Pre-defined database function properties use the following format in the DataBaseFunctions.conf file:

<function_name> - <number_of_arguments>

Database users can also create and define functions for their custom use. Custom functions are called user-defined functions in Microsoft SQL and IBM® DB2®. Functions created as stored procedures in DB2 can also be used for reporting. Functions must be created with the database utilities that are provided by the respective database vendor.

User-defined database function properties use the following format in the DataBaseFunctions.conf file:

user:<function_name> - <number_of_arguments>

Only functions with a single argument are supported in the IBM Verify Identity Governance Report Designer.

Upper

Converts the argument to uppercase.

Example:

Upper - 1

Lower

Converts the argument to lowercase.

Example:

Lower - 1