Answer Posted / sonpal singh

32 is the max record a logical file have...

What is the batch job?

987

---

What is FORMAT keyword and its use?

607

---

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.

1181

---

How to index LF by relative record no (RRN)

3290

---

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?

1124

---

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

975

---

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

998

---

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

1050

---

How to retrieve a physical file after deleting that?

1113

---

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.

2601

---

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

1063

---

How many maximum record format a logical file have?

983

---

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

1045

---

What is the use of member in pf?

990

---

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

1043

---