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.

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.

can error messages as a result of a comp, range or values keyword be overridden?

1 Answers   IBM,

---

Can anybody please tell me what is difference between SQL (STRSQL ) and WRKQRY .....?

3 Answers  

---

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  

---

What is the purpose of 'CPYTOIMPF' command?

6 Answers   Aditya Birla, Redington,

---

What is the maximum number of subfiles that can be specified in a display file?

1 Answers   IBM,

---

how do you read changed records backward in subfile?

0 Answers   IBM,

---

how can I start a page in a new window?

0 Answers   IBM,

---

what are all the contents of subfile?

1 Answers   IBM,

---

Why we have multiple data types in As400 and why we use numeric, packed, decimal, zoned the basic difference between this?

0 Answers  

---

What is journaling & Commitment Control?

1 Answers  

---

List and explain the different type of data structures?

1 Answers  

---

Where would you use Override Data Base File?

4 Answers  

---