Database functions can be created in the data warehouse database (as procedure objects in WhereScape RED) and used in column transformation in WhereScape RED. Refer to SQL Server documentation on functions and Procedures and Scripts for more information on creating functions inside WhereScape RED.
Database function sets can also be created, edited, deleted, imported and exported, using the RED Database Function sets tool.