Using Table Functions to Import Data as a SQLFire Tables

Table functions are functions that package up external data to look like SQLFire tables. The external data can be an XML file, a table in a foreign database, a live data feed--in short, any information source that can be presented as a JDBC ResultSet.

A SQLFire table function lets you efficiently import foreign data into SQLFire tables. Table functions let you join SQLFire tables with any of the following data sources:

The data imported by a table function acts like a SQLFire replicated table that has no indexes. All data is fetched on every SQLFire member where a query against the table is executed. Outer joins that involve a partitioned table and a table function have limitations similar to joins with replicated tables (duplicate values are returned from the replicated table or table function).

See CREATE FUNCTION for the complete syntax needed to declare SQLFire table functions. The following topics provide information on how to write Java methods that wrap foreign data sources inside JDBC ResultSets.