SEL-xxx and Hashed Files

REALITY

For hashed files, mechanisms exist to process multiple items sequentially, either by selecting/sorting a set of items according to specified criteria or by loading a preselected list of item-IDs.

PROIV

PROIV does not support list handling. A sort/select can, however, be performed by a PROIV Paging Cycle if required, although there is performance degradation compared with the native Reality sort/select. For hashed files, the only SEL-xxx statement that is meaningful is SEL-PARTIAL used as follows:

first-key-element = ''

SEL-PARTIAL(first-key-element)

Other SEL-xxx statements result in the following error message:

191 - Cannot Restrict Key Values Using Sel-xxx For Reality File - filename

Click here for more information about the '191' error message.

Comment on this topic

Topic ID: 720209