%Projection.ForeignTableProjection

class %Projection.ForeignTableProjection extends %Projection.AbstractProjection

Method Inventory

• CreateProjection()
• RemoveProjection()

Parameters

parameter COLUMNS;

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

parameter COLUMNSTYPES;

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

parameter NUMFIELDS;

Number of columns in the table (IRIS side)

parameter PREDICATEPUSHDOWN;

Does this FT support predicated pushdown; taken from SERVER

parameter PROJECTS;

Fully qualified SQL name of the foreign table this projection projects

parameter QUERY;

Optional user-specified query to send to the external DB

parameter SERVER;

Name of the server this foreign table belongs to

parameter SQLQUERYNAME;

SQL name given to the FT class query

parameter TABLE;

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

parameter USING;

USING clause at CREATE time

parameter VALUES;

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

Methods

classmethod CreateProjection(classname As %String, ByRef parameters As %String, modified As %String, qstruct) as %Status

Recreate the associated FT

classmethod RemoveProjection(classname As %String, ByRef parameters As %String, recompile As %Boolean, modified As %String, qstruct) as %Status

Drop the associated FT