Answer / Atiya Baqai

CHAIN, SETLCL (Set Last Cursor Location), and SETGTL (Set Get Table) are used in DB400 to manage cursor movement within a file. CHAIN allows moving from one physical or logical file to another, SETLCL saves the last position of the cursor, and SETGTL retrieves the saved cursor location.

WHAT IS THE DIFFERENCE BETWEEN 'COLHDG' AND 'ALIAS'?

5 Answers   Accenture,

---

pls anyone explain about compile time array,pre run time array run time array

4 Answers  

---

How to retrieve a physical file after deleting that?

1 Answers  

---

how to update physical file using logucal file with example

1 Answers   Wipro,

---

can any one pls tell me some differences between a LF and command OPNQRYF?

3 Answers   Accenture, Cognizant, eFunds,

---

How many libraries can be there in a library list?

2 Answers  

---

what is open data path? and what is the diff b/w access path and open data path?

3 Answers   Cap Gemini,

---

How to update physical file using logical file with example?

1 Answers  

---

Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any duplicate records in this pf.Based on this pf one Logical file i have used.But this lf is viewing only 80 records only of that pf?What is the reason for this?Please give me answer?

4 Answers   IBM,

---

how can i know logical file belongs to which physical file without source?

4 Answers   Cap Gemini,

---

Where the QTEMP library will get created? if the the answer is QSYS, then howcome more than one job can create same library name(QTEMP) in QSYS? what is the uniqueness of QTEMP? For example, run the below command in different workstation WRKOBJ QSYS/QTEMP And take 8 in the option to check the description. both will have different info. so where(which LIB) exactly the QTEMP is stored?

3 Answers  

---

How to index LF by relative record no (RRN)

1 Answers  

---