Multiple choice technology mainframe

Requirement is to read all the distinct values of following fields from a table called 'IDENTIFICATION-TABLE'. Fields need to be extracted are 1) IDENT-ID 2) IDENT-NAME 3) IDENT-AGE Super to be used for this requirement is SUPER-ID-NAME-AGE (combination of above fields). Which statement will be used to read the data efficiently from IDENTIFICATION-TABLE?

  1. Read Statement

  2. Find Statement

  3. Histogram Statement

  4. Get Statement
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The HISTOGRAM statement in Natural/ADABAS is specifically designed for efficiently retrieving distinct values (unique occurrences) from specified fields, which is exactly what this requirement needs.

Keep practicing — related questions