%Projection.ForeignTableProjection

Class %Projection.ForeignTableProjection Extends %Projection.AbstractProjection

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

NUMFIELDS;

Parameter NUMFIELDS;

Number of columns in the table (IRIS side)

PREDICATEPUSHDOWN;

Parameter PREDICATEPUSHDOWN;

Does this FT support predicated pushdown; taken from SERVER

PROJECTS;

Parameter PROJECTS;

Fully qualified SQL name of the foreign table this projection projects

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

SQLQUERYNAME;

Parameter SQLQUERYNAME;

SQL name given to the FT class query

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

Methods

CreateProjection

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

Recreate the associated FT

RemoveProjection

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

Drop the associated FT