Versions Compared

Key

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

...

  • GROUP_BY commands help you simplify your code.
  • You should always check the I/O status after performing database operations. The IF_STATUS command supports *OKAY, *ERROR, *VALERROR, *NORECORD, *ENDFILE, *BEGINFILE, *EQUALKEY, *NOTEQUALKEY.
  • Program level validation rules can be added using a BEGINCHECK / ENDCHECK and related validation commands CALLCHECK, CONDCHECK, DATECHECK, FILECHECK, RANGECHECK, VALUECHECK, IF_ERROR, SET_ERROR.
  • A record should be fetched from the database prior to updating or deleting it, if you are not using a key to identify the record. For more details about cross-update and delete, please refer to DELETE Comments / Warnings and Understand the UPDATE Command in UPDATE Comments / Warnings in the Technical Reference Guide.
  • LANSA provides many Built-In Functions that can be used to perform specialized tasks in LANSA. Intrinsic field methods are now used in place of many of these Built in Functions.
  • The SUBROUTINE / ENDROUTINE defines a routine that you can EXECUTE from any other routine in your form. Subroutines cannot be defined within an event, method or property routine.

...