Versions Compared

Key

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

...

  • A field name should be 9 characters or less and should not contain an '#' or '@' symbol.
  • The xxxxxx part of the name should be 1 to 6 characters and as meaningful as possible given the size limitation. For example: PARTNO- Part Number, CUSTNO- Customer Number, SALQTY- Sales Quantity.
  • The iii is optional and should be used for "working" or temporary versions of the original xxxxxx field in RDML functions.   The iii suffix should be standardized and only a limited number of variations allowed. For example: WRK- working value of the field VIR- virtual field definition TOT- totaled value of the field.
  • All iii suffix versions of the field should be defined in the Repository.

...

  • Table definitions should only contain xxxxxx field names (with the exception of virtual fields and predetermined join fields).
  • Do not define fields in RDML functions, even when the reference field option is used.   This greatly strengthens the cross-referencing power of LANSA.   Use the reference field option wherever possible.

...