PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

Explain the difference between normal AS/400 file definition and Lansa file Definition?

View previous topic View next topic Go down

Explain the difference between normal AS/400 file definition and Lansa file Definition?

Post  maran on Sun Oct 14, 2012 11:30 pm

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
avatar
maran
Admin

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum