HP 3000 Manuals

Information Access Server: Learning the Administrator Utility

Lesson Summary 

Congratulations again!  You have successfully defined several complex
view tables.

In this lesson, you learned how to:

   *   Select IMAGE table items in three different ways.

   *   Select and sort retrieved records.

   *   Combine data from more than one table using the JOIN operation.

   *   Define part of an item as a separate item using the SUB function.

   *   Calculate a new item by using a mathematical expression on the
       values in other items.

   *   Substitute full words for "coded" data using a CASE statement.

   *   Resolve a compound data item into several individual items.

   *   Calculate the average value of a compound item and the sum of its
       components by using ROW functions.

MPE/iX 5.0 Documentation