Skip to main content

EnsLib.EDI.XML.SearchTable

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

SQL Table Name: EnsLib_EDI_XML.SearchTable

Defines a set of properties derived from Document objects of class 'EnsLib.EDI.XML.Document' that can be used in SQL to locate and join to messages of interest.

Parameters

parameter DOCCLASS = EnsLib.EDI.XML.Document;
Inherited description: The class of Document object for which this SearchTable subclass is designed.
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.EDI.XML.SearchTable)

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