Skip to main content

INFORMATION.SCHEMA.FOREIGNSERVERS

persistent class INFORMATION.SCHEMA.FOREIGNSERVERS extends %Library.Persistent

SQL Table Name: INFORMATION_SCHEMA.FOREIGN_SERVERS

This table has one row for each Foreign Server the users is privileged for in the current namespace

Property Inventory

Parameters

parameter READONLY = 1;
Inherited description: READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.

Properties

property ClassName as %String (MAXLEN = 256) [ SqlFieldName = CLASSNAME , Required ];
Property methods: ClassNameDisplayToLogical(), ClassNameGet(), ClassNameIsValid(), ClassNameLogicalToDisplay(), ClassNameLogicalToOdbc(), ClassNameNormalize(), ClassNameSet()
property Description as %String (MAXLEN = 256) [ Calculated , SqlFieldName = DESCRIPTION ];
Property methods: DescriptionCompute(), DescriptionDisplayToLogical(), DescriptionGet(), DescriptionIsValid(), DescriptionLogicalToDisplay(), DescriptionLogicalToOdbc(), DescriptionNormalize(), DescriptionSQLCompute()
property ForeignDataWrapper as %String (MAXLEN = 256) [ Calculated , SqlFieldName = FOREIGN_DATA_WRAPPER ];
Property methods: ForeignDataWrapperCompute(), ForeignDataWrapperDisplayToLogical(), ForeignDataWrapperGet(), ForeignDataWrapperIsValid(), ForeignDataWrapperLogicalToDisplay(), ForeignDataWrapperLogicalToOdbc(), ForeignDataWrapperNormalize(), ForeignDataWrapperSQLCompute()
property Owner as %String (MAXLEN = 256) [ Calculated , SqlFieldName = OWNER ];
Property methods: OwnerCompute(), OwnerDisplayToLogical(), OwnerGet(), OwnerIsValid(), OwnerLogicalToDisplay(), OwnerLogicalToOdbc(), OwnerNormalize(), OwnerSQLCompute()
property ParameterString as %String (MAXLEN = 3200) [ Calculated , SqlFieldName = PARAMETERS ];
Property methods: ParameterStringCompute(), ParameterStringDisplayToLogical(), ParameterStringGet(), ParameterStringIsValid(), ParameterStringLogicalToDisplay(), ParameterStringLogicalToOdbc(), ParameterStringNormalize(), ParameterStringSQLCompute()
property ServerName as %String (COLLATION = "UPPER", MAXLEN = 128) [ SqlFieldName = SERVER_NAME , Required ];
Property methods: ServerNameDisplayToLogical(), ServerNameGet(), ServerNameIsValid(), ServerNameLogicalToDisplay(), ServerNameLogicalToOdbc(), ServerNameNormalize(), ServerNameSet()
property ServerSchema as %String (COLLATION = "UPPER", MAXLEN = 128) [ SqlFieldName = SERVER_SCHEMA , Required ];
Property methods: ServerSchemaDisplayToLogical(), ServerSchemaGet(), ServerSchemaIsValid(), ServerSchemaLogicalToDisplay(), ServerSchemaLogicalToOdbc(), ServerSchemaNormalize(), ServerSchemaSet()

Inherited Members

Inherited Methods

Storage

Gray indicates storage defined by superclasses.

Storage Model: SQLStorage

Maps: 1

  • Map number 1 is named Master

    thismap.Global: ^rINDEXSQL

  • ^rINDEXSQL("SERVER",{SchemaExact},{ServerExact})
    =
    Node Delimiter Piece Name
    SERVER_SCHEMA
    1 CLASSNAME
FeedbackOpens in a new tab