XDFLD statement overview

The XDFLD statement is used only when a secondary index exists.

It is associated with the target segment and specifies:
  • The name of an indexed field.
  • The name of the source segment. The source segment can be the same as the target segment or a dependent of the target segment.
  • The field in the source segment that contains the data that is used in the secondary index.

Up to 32 XDFLD statements can be defined per segment. However, the number of XDFLD and FIELD statements combined cannot exceed 255 per segment or 1000 per database.

Restriction: The CONST parameter is not allowed for a HALDB database. Shared secondary indexes are not supported.
Parent topic: Coding database descriptions as input for the DBDGEN utility
Related reference:
XDFLD statements