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...

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.

2533

---

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

1021

---

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

981

---

What is the interactive job?

958

---

What is the primary file?

1055

---

How to change the batch job to interactive job?

923

---

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

951

---

What is FORMAT keyword and its use?

550

---

How to index LF by relative record no (RRN)

3238

---

What is the batch job?

930

---

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

988

---

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

1046

---

How many maximum record format a logical file have?

935

---

Last statement of any rpg program is lr?

1027

---

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

924

---