Explain the difference between normal AS/400 file definition and Lansa file Definition?
Page 1 of 1
Explain the difference between normal AS/400 file definition and Lansa file Definition?
In AS/400 terms a file definition contains:
• The fields that make up the format of the file records.
• Logical views of the file those are required. The logical views may contain select/omit criteria.
In addition the LANSA file definition may also contain:
• Validation rules that are to be performed on fields when records are added or updated or deleted.
• Access routes from the current file to other files in the system. This facility allows users to access a complete database without having a detailed knowledge of its structure.
• Predetermined join fields, which use the current file’s, access routes to retrieve information from related files.
• Virtual field definitions. These are fields that are not actually present in the database file but are "derived" from fields that are in it. Hence the name "virtual". These fields appear as if they are in the file, even though they aren't.
Batch control logic, which specifies other files in the system that contain batch, control or summary totals of information in the current file. LANSA will ensure that the summary or control information in other files is automatically maintained
• The fields that make up the format of the file records.
• Logical views of the file those are required. The logical views may contain select/omit criteria.
In addition the LANSA file definition may also contain:
• Validation rules that are to be performed on fields when records are added or updated or deleted.
• Access routes from the current file to other files in the system. This facility allows users to access a complete database without having a detailed knowledge of its structure.
• Predetermined join fields, which use the current file’s, access routes to retrieve information from related files.
• Virtual field definitions. These are fields that are not actually present in the database file but are "derived" from fields that are in it. Hence the name "virtual". These fields appear as if they are in the file, even though they aren't.
Batch control logic, which specifies other files in the system that contain batch, control or summary totals of information in the current file. LANSA will ensure that the summary or control information in other files is automatically maintained
Similar topics
» What? A high speed table is not a "thing" in itself. A high speed table is a normal LANSA file definition that has its "high speed" flag set to YES. • A LANSA file definition flagged as high speed table is actually implemented as a normal database file.
» What are the reasons a logical file may be "dropped" during the File definition load process?
» Where did the changes to the file definition go?
» What Happens When a File Definition Is Loaded (or Re-Loaded)?
» How to convert DDS to SQL Data Definition Language (DDL) commands?
» What are the reasons a logical file may be "dropped" during the File definition load process?
» Where did the changes to the file definition go?
» What Happens When a File Definition Is Loaded (or Re-Loaded)?
» How to convert DDS to SQL Data Definition Language (DDL) commands?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum