You are here: LANSA for i User Guide > 3. Files > 3.15 Virtual Fields > 3.15.2 Steps to Define, Review or Change Virtual Fields

3.15.2 Steps to Define, Review or Change Virtual Fields

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

 

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 |

|          |    |           |    |           |    |           |

|__________|    |___________|    |___________|    |___________|

 

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