Answer Posted / keshar jain

We can positioned to nth record in file in CL with the help of OVRDBF command.
Synatax:

OVRDBF FILE(file-name) POSITION(*RRN 11)

This will positioned file on 11th record so RCVF command will read 11th record in file.

If you want to read with key conditioned then we can specify *KEY,*KEYA,KEYAE etc to positioned with key specified in command.

What is the interactive job? What is the batch job?

993

---

How to update physical file using logical file with example?

1023

---

What is the interactive job?

972

---

What is FORMAT keyword and its use?

564

---

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?

1077

---

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

1072

---

In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.

2553

---

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.

1140

---

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

1068

---

How to read a pf in reverse(from last record to first) using cl?

1073

---

What is open data path?

957

---

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

938

---

When we create a pf and did not fill up maint parameter, then by default which access path will the system take & why?

1041

---

How many maximum record format a logical file have?

945

---

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

1000

---