Answer / Reshu Kumari

In DB400, you can update a physical file (PHLFILE) using a logical file (LLLFILE) by using the SQL UPDATE statement. Here's an example:nn```sqlnSET EXEC SQLnUPDATE PHYSICAL_FILE SET COLUMN1 = 'New Value 1', COLUMN2 = 'New Value 2' WHERE KEY_COLUMN = 'Key Value';nEND-EXEC;n``

What is the interactive job? What is the batch job? How to change the batch job to interactive job?

1 Answers  

---

Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...

6 Answers   ABC, TCS,

---

What is open data path?

1 Answers  

---

hi iam very new to as400. i had created one physical file can any one tell command to enter data in to that

9 Answers   Encore,

---

what is the difference between adding keys & constraints into a phisical file

4 Answers   HSBC,

---

When we use any keyword like FIFO,LIFO, at file level but whenever we check by runqry we couldn't find answer in FIFO,LIFO,FCFO etc so how we check the answer.

2 Answers  

---

When u create a PF and did not fill up Maint parameter, then by default which access path will the system take & why

2 Answers   HCL,

---

wirte a simple program for read file in cl

2 Answers   Active Brains,

---

one physical file can have how many max of logical files? what is the primary file?

3 Answers   Four soft,

---

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

4 Answers  

---

I have a pf, it contains 5 members, how to access particular member data from logical file?

1 Answers  

---

How can we handle errors in RPG?

4 Answers  

---