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

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!