Warning about Fetch fields
| Date: | Archived |
|---|---|
| Product/Release: | LANSA for the AS/400 |
| Abstract: | Be careful when using parameters *ALL, *ALL_REAL and *ALL_VIRT - only use them when necessary |
| Submitted By: | LANSA Technical Support |
Description:
Since LANSA Release 7.0 it has been possible to use the parameters *ALL, *ALL_REAL and *ALL_VIRT with all I/O commands. This can be very useful when accessing all the fields of a record without having to explicitly define them.
However, this can also be dangerous. All the fields are accessed via the parameter *ALL, when this is not really necessary in most cases.
This results in a decrease in performance and illogical cross reference details (fields are defined which are not really used). Another disadvantage is that the Crude Entity Complexity Rating of the LANSA function will be unnecessarily larger.
Only use these parameters when it is essential!
