Skip to main content

%Library.AbstractForeignTable

Class %Library.AbstractForeignTable [ Abstract ]

Parameters

COLUMNS;

Parameter COLUMNS;

String of header names for FILE foreign tables to specify column order in the header

COLUMNSTYPES;

Parameter COLUMNSTYPES;

Types specified in the COLUMNS clause; included for parity with LOAD DATA

NUMCOLUMNS;

Parameter NUMCOLUMNS;

Number of columns in the table (IRIS side)

PREDICATEPUSHDOWN;

Parameter PREDICATEPUSHDOWN;

Does this FT support predicated pushdown; taken from SERVER

PROJECTEDBY;

Parameter PROJECTEDBY;

Name of the class that projects this foreign table

QUERY;

Parameter QUERY;

Optional user-specified query to send to the external DB

SERVER;

Parameter SERVER;

Name of the server this foreign table belongs to

TABLE;

Parameter TABLE;

Name of the table as it exists in the external data source

USING;

Parameter USING;

USING clause at CREATE time

VALUES;

Parameter VALUES;

Comma-delimited string of column names as they exist in the external table