Table functions generate tables whose content depends on the call parameters or is derived from external data sources, e.g. files.
The following table functions are provided in SESAM/SQL:
CSV()
returns a table whose values are read from a BS2000 file (the so-called CSV file)DEE()
returns a table with a row without columns
CSV format (CSV: Comma Separated Values) is used to display SQL tables in files here. This is a standardized format for the platform-independent exchange of table data. The file contains the sequence of table rows, each row containing its column values sequentially as a string. Such files can be generated with a large number of software products (e.g. with Microsoft EXCEL). Further details on CSV format and on interpreting CSV files is provided in the “ SQL Reference Manual Part 1: SQL Statements”.