HP 3000 Manuals

Lesson 4: Quiz 2 [ HP ALLBASE/BRW Tutorial ] MPE/iX 5.0 Documentation


HP ALLBASE/BRW Tutorial

Lesson 4:  Quiz 2 

   1.  How many selection sets and parameters can you have in a report?

              You can have up to 50 parameters and up to 50 selection
              sets for one report.  If you want further selection sets,
              just copy the report, delete a few sets and define new ones
              to the limit of 50.

   2.  What is the difference between the parameter result (or data) type 
       and the type of parameter?

              The parameter result is the data type of the parameter,
              that is, either String (S), Date (D), Time (T), Real (R),
              Integer (I), or Numeric (N). The type of parameter is
              either Single-value (S), List-of-values (L), or Comparison
              Predicate (P).

   3.  "The main difference between a relation condition and a selection
       condition is that the relation condition is evaluated earlier and
       so is more efficient." True or False?

              False.  There is no difference in efficiency; both
              conditions are evaluated as early as possible.  The only
              difference between relation and selection conditions is
              that relation conditions always apply to a report, and
              selection conditions apply only if the report is compiled
              with the appropriate selection set.

   4.  "Unless you include a parameter in a selection set and compile the
       report with that selection set, you cannot give a value for that
       parameter at run time." True or False?

              True.  You must include the parameter in the selection set
              and then compile the selection set with report.

   5.  "You can use any operator with a comparison predicate parameter."
       True or False?

              False.  Comparison predicate parameters can only be used in
              formulas with the operator SATISFIES (and the logical
              operator NOT). You can supply any arithmetic operator and
              value at run time for a comparison predicate parameter, but
              in the formula, only SATISFIES can be used.



MPE/iX 5.0 Documentation