Creating a UDTF written in Lua

This section uses examples to illustrate how to create, on a Db2® system, a user-defined table function (UDTF) written in Lua.

UDTF in Lua: Example 1
This example creates a function called split_to_rows that splits a character string into rows based on the position, in the string, of a delimiter character.
UDTF in Lua: Example 2
This example creates a function called unpivot_final that unpivots sales data that is stored in a row containing sales by quarter into four rows of data, one for each quarter. It also returns an additional row that contains the total value of all sales.
UDTF in Lua: Example 3
This example creates a function called shaper that dynamically shapes an output table. Instead of providing the names and data types of the output columns, this example calls, at runtime, the calculateShape function to dynamically determine which name and data type to assign to each output column.

Parent topic: Creating UDX source files in Lua