Method and system for nested SQL functions for net.data on workstations

摘要

The present invention provides a system and method for providing nesting Structured Query Language (SQL) functions. The method includes: calling a first SQL function; processing a first result table for the first SQL function; determining that the first result able comprises a second SQL function; calling the second SQL function; processing a second result table of the second SQL function; returning a result for the second SQL function; resuming processing of the first result table; and returning a result for the first SQL function. The method and system allows a Net.Data system to call SQL functions from within a result table of another SQL function. The level of nesting is maintained for an array of SQL statement handles to ensure that the proper handles are used. In this manner, auxiliary tables are not required, simplifying the programming of Net.Data queries and decreasing memory overhead.