Skip to main content
2024.3
AskMe (beta)

%Projection.ForeignTableProjection

class %Projection.ForeignTableProjection extends %Projection.AbstractProjection

Method Inventory

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

Inherited Members

Inherited Methods

FeedbackOpens in a new tab