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

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

Join the forum, it's quick and easy

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

Get Answers for all your queries on IBM i (AS/400).
PMS Information Systems
Would you like to react to this message? Create an account in a few clicks or log in to continue.

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

Go down

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

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

Posts : 442
Join date : 2009-07-24

https://pmsinformationsystem.forumotion.net

Back to top Go down

Back to top

- Similar topics

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