Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The steps involved in defining, reviewing or changing virtual fields in a file definition are as follows: 


No Format
nopaneltrue
1.

...

 Select the option to   ___________

...


 "Define virtual fields  |           |
 in file definition" or  |   FILE    |
 "Review or change       | DEFINITION|
 virtual fields in file  |   MENU    |
 definition" from the    |___________|

...


 file definition menu.        |    
                              |
                              |
                          ____|______

...


2.

...

 Define,

...

 review,

...

 change|           |
 or delete virtual       |  VIRTUAL  |
 fields defined in the   |  FIELDS   |
 file using the          |  IN FILE  |
 resulting display.      |___________|

...


                               |     \
                               |      \___________

...


                               |                  |
3. Optionally review or   _____|___

...

__        _____|____

...

_   Optionally
 modify the extended     |           |      |           |  review or
 definition for the      |  VIRTUAL  |      |  VIRTUAL  |  modify the
 virtual field by        |   FIELD   |  OR  |   FIELD   |  RPG/400 code
 specifying the type of  | EXTENDED  |      | RPG CODE  |  that is used
 action to derive the    |DEFINITION |      |___________|

...

  to derive
 virtual fields.         |___________|

...

                     virtual field
      __________________/

...

     / \     \_________________

...


     |                 ______/

...

   \_____

...

                 |
     |                |                |                |
 ____|_____      __

...

___|____

...

_      _____|____

...

_      _____|____

...

          

...

    

...

           

...

    

...

           

...

    

...

           

...

SUBSTRING 

...

    

...

 CONCAT'S  

...

    

...

   MATHS   

...

    

...

   DATE    

...

          

...

 OR 

...

           

...

 OR 

...

CALCULATION

...

 OR 

...

CONVERSION 

...

          

...

    

...

           

...

    

...

           

...

    

...

           

_
|          |    |           |    |           |    |           |
|SUBSTRING |    | CONCAT'S  |    |   MATHS   |    |   DATE    |
|          | OR |           | OR |CALCULATION| OR |CONVERSION |
|          |    |           |    |           |    |           |
|__________

...

    

|    |___________

...

    

|    |___________

...

    

|    |___________

...

|
 
4. Derive        Derive virtual   Derive virtual   Derive virtual
virtual field    field by a       field by a       field by a
by substringing  concatenation    mathematical     date conversion
a field/record   of fields        calculation      of a field