Please enable JavaScript.

Coggle requires JavaScript to display documents.

Lookup, Loading a whole lookup data file from disk into memory once, and…

- - - - lookup_next Function
        let integer(4) i = 0;
        let integer(4) n = lookup_count("MyLookup", in.key);
        et my_type[integer(4)] result_vector = for (i, i < n) : lookup_next("MyLookup");
      - Static - lookup("parts_info", in.part_number).mfr_date
        Dynamic - lookup(lookup_identifier_type lookup_id, string lookup_template [ , expr ... ] )
        Returns first record
      - record lookup_previous(string lookup_file)
      - lookup_nth
        lookup_count("MyLookup", "Jane Doe")
        lookup_nth("MyLookup", 16)
- - - - In exact lookup operations, DML key modifiers for sort direction, sort sequence, and grouping can be added and mixed with the optional exact lookup key modifier, if present.
      - An interval lookup key specifies an upper and lower bound to matching key values, rather than a single, exact value. Interval lookup key values must be ordered, and that ordering can be altered by changing the sort direction (DML key modifier ascending or descending).
      - An indexed block-compressed lookup data file must be created from sorted data. The ordering and searching of block-compressed lookup data can be altered by modifying sort direction (DML key modifier ascending or descending) and by other DML key modifiers (like foldcase) that alter the equivalence or sort sequence of field values with character data.
        The key that you use to presort the data determines the order and equivalence of records in the resulting lookup file and controls how its index is constructed. This key must be the basis for any later search of the compressed lookup data.
- - - - Lookup type by data and operation
        Serial Vs Multifile (Partitioned)
        Static Vs Dynamic
        Non compressed Vs Block Compressed
      - Location, scope, and permanence (or transience) of the lookup data
      - Present and future size of the lookup dataset