What is the benefit of using Externally Described files
over Internally
Described?
Answer Posted / ankush chaudhary
Defining data files as externally described has several
advantages over program desribed files:
1. If you design the file using database design principles,
externally defined files can reduce the need for
duplication of data across fiels. This kind of duplication
is called redundancy. Because all programs using a given
file use the same field definition and names. Externally
described files impose standardisation among programs and
across applications.
2. Externally described also also increase programmers
efficiency and reduces errors because programmers don't
need to duplicate the file definition effort each time they
need to reference a file within the a program.
3. If it is necessary to add a field to a fiels records or
to change a fields definition, these changes need to made
in only one place (in the externally described file) rather
than in every program that uses that file. THus simplifying
maintenance.
Hope this much difference is suffient :))
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
what do we can do with the embedded sql statements?
how will you find a string using pdm?
how to pick up the changed records every time in a subfile after the first change made ?
when would you prefer logical file than opnqryf?
what is the disadvantage of using global variable?
what is the purpose of dynslt keyword?
If i change any file through application after entering data , how to check which file is updated through applications . For call stack we takes esc 3 then we chose 11..But What is answer of below qtn..?
How do you check object lock
which indicator is used for read?
how many types of display are available on as/400 for user interaction?
when do you use f-spec. Continuation line ?
what would be the effect on the field where reverse image, underline and highlight display attributes are active ?
what is the use of dspatr(mdt) keyword?
define the rcvf command?
what is the difference between udate and the system date?