Product Documentation

FairCom DB API for C

Previous Topic

Next Topic

SQL - Dynamic file list for dynamic partitions syntax change

The SQL grammar has been extended to support a new way of specifying the table name for SQL queries as follows. Originally, the grammar was to use the keyword cttbl, which was rather obscure and not self-explanatory as other SQL keywords are. This keyword name has been changed from cttbl to fileset so the syntax is as follows:

table_ref ::

table_name [ AS ] [ alias [ ( column_alias [ , ... ] ) ] ]

| ( query_expression ) [ AS ] alias [ ( column_alias [ , ... ] ) ]

| [ ( ] joined_table [ ) ]

| fileset(table_name [,"file_list"])[ AS ] [ alias [ ( column_alias [ , ... ] ) ] ]

TOCIndex