what is difference between accespath and datapath?
what is the difference between accespath and open datapath?

Answers were Sorted based on User's Feedback



what is difference between accespath and datapath? what is the difference between accespath and ope..

Answer / s.kumar

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

what is difference between accespath and datapath? what is the difference between accespath and ope..

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

Post New Answer

More IBM AS400 AllOther Interview Questions

1) Suppose we call a pgm from CL, how come AS400 system knows whether the called pgm is to be interactive one or batch one? 2)How many members can exist in a PF?

7 Answers  


which are the string manipulation opcodes?

0 Answers   IBM,


How do you check object lock

0 Answers  


What is the type, length of a LDA?

1 Answers  


in conjunction with what other keyword must ovrdta and ovrata be used?

1 Answers   IBM,






what is *inzsr used for?

1 Answers   IBM,


how to validate input values in display file ?

0 Answers   IBM,


where can you specify an indicator in lokup operation?

1 Answers   IBM,


how do we know batch job aborted after we submitting it

1 Answers  


what are the necessary keywords for the join logical file?

2 Answers   IBM,


To Add A File To The 'file Selection' Option Of A Query, The Function Key To Be Pressed Is?

0 Answers   IBM,


What is a job log?

1 Answers  


Categories