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.

0 Answers   Nous,

---

what is error handling concepts in cl

3 Answers   Active Brains,

---

Why we create the Physical File Member?

5 Answers  

---

1. How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name? 2. How to differentiate between the types of join from a Join logical file DDS. Is it possible to have different types of Join Logical files? 3.Any performance difference between Opnqrf and Embedded SQL? When I should prefer Opnqryf and when SQL? 4. I know access path is the path chosen by the program to retrieve data. It can be of keyed access path or arrival sequence. *IMMED- *IMMED description says access path is updated each time record is added or deleted from a member. - What is updating here? *REBLD - The access path is completely rebuilt each time a file member is opened. The access path is maintained until the member is closed, then the access path is deleted. - I am not able to understand this completely. Could anyone explain these more clearly? 5.What is the purpose of using activation group. I know it is a resource allocator, but other than this any other benefits of using an activation group?

2 Answers   IBM,

---

what is multiple member pf

1 Answers   Active Brains,

---

can any one pls tell me some differences between a LF and command OPNQRYF?

3 Answers   Accenture, Cognizant, eFunds,

---

what is dynslt and why we use that command when do we use command

2 Answers   Active Brains, UHG,

---

what is the intractive job? what is the batch job ? how to change the batch job to interactive job?

2 Answers   Four soft,

---

Which keyword is used both in subfile and subfile control record format of a DSPF?

8 Answers  

---

What is FORMAT keyword and its use?

0 Answers  

---

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

1 Answers  

---

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

0 Answers  

---