Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
The Persistent attribute hash table concept cover attributes of the following data types: SdaiString / sdaiSTRING SdaiInteger /sdaiINTEGER SdaiInstance / sdaiINSTANCE EdmiPackedDate / edmPACKED_DATE
Code Block
languagecpp
themeConfluence
FUNCTION xpxDefinePersistentAttrHashTableBN (schemaName     : STRING;
                                             entityName     : STRING;
                                             attributeName  : STRING;
                                             options        : INTEGER;
                                             hashTableWidth : INTEGER;
                                             stringLength   : INTEGER)
                                             status         : INTEGER;    
                                                     
 

 

The Persistent attribute hash table concept cover attributes of the following data types:

  • SdaiString / sdaiSTRING
  • SdaiInteger /sdaiINTEGER
  • SdaiInstance / sdaiINSTANCE
  • EdmiPackedDate / edmPACKED_DATE

The xpxDefinePersistentAttrHashTableBN function is used to define a persistent hash table to increase search speed in the database. A hash table is a persistent data structure in the database that speeds up the search for instances of one entity in one schema via the value of one attribute. Input parameters are defined for corresponding edmi-function. The hash table is created when a data model of the specified schema is created and it is maintained during the entire lifetime of the model or until it is deleted. If there exist a data model based on the specified schema when the hash table is defined, this model do not get a hash table. In this case the model must be exported to a STEP file, deleted and recreated from the STEP file. Likewise is not an attribute hash table of data model removed if the attribute hash table definition is removed from the underlying schema of the data model.

This function defines attribute hash table connected to the specified attribute in the specified schema.

 

Arguments

...

Insert excerpt
US:_a_schemaName
US:_a_schemaName
nopaneltrue
Insert excerpt
US:_a_entityName
US:_a_entityName
nopaneltrue
Insert excerpt
US:_a_attributeName
US:_a_attributeName
nopaneltrue
Insert excerpt
US:_a_options_XPX
US:_a_options_XPX
nopaneltrue
Insert excerpt
US:_a_hashTableWidth
US:_a_hashTableWidth
nopaneltrue
Insert excerpt
US:_a_stringLength
US:_a_stringLength
nopaneltrue

Return Value

...

Insert excerpt
US:_r_XPX_Return_Value
US:_r_XPX_Return_Value
nopaneltrue

Options

...

Insert excerpt
US:_o_DELETE_ATTRIBUTE_HASH_TABLE
US:_o_DELETE_ATTRIBUTE_HASH_TABLE
nopaneltrue
Insert excerpt
US:_o_REDEFINE_ATTRIBUTE_HASH_TABLE
US:_o_REDEFINE_ATTRIBUTE_HASH_TABLE
nopaneltrue
Insert excerpt
US:_o_SUBTYPES
US:_o_SUBTYPES
nopaneltrue
Insert excerpt
US:_o_FIXED_STRING_LENGTH
US:_o_FIXED_STRING_LENGTH
nopaneltrue
Insert excerpt
US:_o_UNIQUE_ATTRIBUTE_VALUES
US:_o_UNIQUE_ATTRIBUTE_VALUES
nopaneltrue

 

Example

...

<example missing>

 

See also

Filter by label (Content by label)
showLabelsfalse
showSpacefalse
cqllabel = "hashedattribute" and parent = "5636522"