INTRODUCTION: ------------ This example illustrates the use of LibDMI calls from within a server UDR. It queries for a column in a table and returns the values as a set. While it primarily illustrates the use of LibDMI calls and query processing in general, it also illustrates the use of sets and returning sets in a server UDR. RUNNING TESTS: ------------- The following steps describe how to register and test this blade. 1. Install the blade and register it to a database. 3. Run 'main.sh all' and this will run the functional tests. DESCRIPTION: ----------- This blade defines one function function CIter( boolean ) returns set( money not null ); The function depends on the following schema. table blt_tab ( bool_col boolean, money_col money, set_col set(money not null) ); This table is created in a custom SQL script, that gets executed when the DataBlade is registered. The final set_col is to ensure that the set( money not null) type always exists. It executes the query "SELECT money_col FROM blt_tab WHERE bool_col = b" where b is the boolean argument to the function.