Product Documentation

c-treeACE V11.0 Update Guide

Previous Topic

Next Topic

Table Valued Functions

Table valued functions make dynamic table query available by allowing calculated stored procedure results to be used in place of a table reference in the FROM clause of a SELECT statement.

Example

Consider a stored procedure that builds a list of customers given a set of parameters:

proc_get_overdue_customers_by_zip (

IN zip CHAR(5),

IN calc_by_days INTEGER

)

RESULT (last_name CHAR(20), first_name CHAR(20), balance_due MONEY, days_overdue INTEGER)

As a table valued function, this procedure can be directly referenced in your SELECT statement.

SELECT last_name, first_name, balance_due, days_overdue FROM proc_get_overdue_customers_by_zip('65203', 90);

TOCIndex