Answer Posted / gatla

PF::A R RCD
A NAME 9A ALIAS(YOUR)
A AGE 2P COLHDG('IN YEARS')


OUTPUT: 000001 KARU 57
000002 LAV 24
000003 MAI 24

I THINK NOW YOU HAVE CLEAR IDEA.... RIGHT...

How to update physical file using logical file with example?

1063

---

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

1002

---

How to change the batch job to interactive job?

995

---

What is the difference between access path and open data path?

1113

---

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

983

---

I have physical 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?

1109

---

What is FORMAT keyword and its use?

615

---

What is the purpose of the chain and setll and setgt?

1047

---

There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.

1184

---

Suppose I have a pf,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in pf?

1060

---

Can we concatenate fields in physical file? If yes how can we do?

1057

---

How to retrieve a physical file after deleting that?

1121

---

What is the interactive job?

1029

---

How to know the particular record in pf with out reading?

1069

---

What is the primary file?

1139

---