Skip to main content

EnsLib.XML.SearchTable

persistent class EnsLib.XML.SearchTable extends %Library.Persistent, Ens.VDoc.XMLSearchTable

SQL Table Name: EnsLib_XML.SearchTable

Defines a set of properties derived from XML Stream objects embedded in class 'Ens.StreamContainer' that can be used in SQL to locate and join to XML documents of interest.

Parameters

parameter EXTENTSIZE = 4000000;
Inherited description: The EXTENTSIZE parameter is used to inform the SQL Query Optimizer of the approximate number of instances in the extent containing instances of this class.

For example, a class that expects to have about 1,000,000 instances should define:

parameter EXTENTSIZE = 1000000;

Indexes

index (indexDocId on DocId,PropId,PropValue) [Unique];
Index methods: indexDocIdCheck(), indexDocIdCheckUnique(), indexDocIdDelete(), indexDocIdExists(), indexDocIdOpen(), indexDocIdSQLCheckUnique(), indexDocIdSQLExists(), indexDocIdSQLFindPKeyByConstraint(), indexDocIdSQLFindRowIDByConstraint()
index (indexValue on PropId,PropValue,DocId) [IdKey, Type = key, Unique];
Index methods: indexValueCheck(), indexValueDelete(), indexValueExists(), indexValueOpen(), indexValueSQLCheckUnique(), indexValueSQLExists(), indexValueSQLFindPKeyByConstraint(), indexValueSQLFindRowIDByConstraint()

Inherited Members

Inherited Properties

Inherited Methods

Storage

Storage Model: Storage (EnsLib.XML.SearchTable)

^EnsLib.XML.SearchTableD(ID)
=
%%CLASSNAME
FeedbackOpens in a new tab