what is difference between accespath and datapath?
what is the difference between accespath and open datapath?
Answers were Sorted based on User's Feedback
Access Parh: Describes the Order in which records are to
be retrieved i.e Sequential Access path ,Keyed Access path.
Open Data Path: Provide the way for more then one program
in the same job to share the same file information like
file pointer position, storage area.
It is quite useful to improve the performances and reduces
the open/close file.
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / abhishek bajpai
U can understand it like...access path is internal to file
and data path is external to it.
Access path is the order in which the records in a file are
retrieved. Whereas the datapath is the connection between
the program and the database file.
So if a program is using the data basefile, it connects to
the file by using the datapath (which can be share also)
and then retrieves its records based on the order requried
using the access path.
| Is This Answer Correct ? | 8 Yes | 2 No |
what are the two record formats a subfile contain ?
What are all the compiler directive statements?
What is the difference between regular logical file and join logical file?
What is the exact difference between Service Program and Binding Directory?
What is the purpose of the following I UDS I 1 60ORDER# I 7 90LINE#
what is the purpose of ovrdta (override data) keyword?
what is the difference between packed decimal and zoned decimal?
what do we can do with the embedded sql statements?
when are the unique constraints executed?
why is as/400 called object oriented machine?
How we can delete all the Logical File of a Physical file in one instance ?
where exactly we can use OPNQRYF ?