Answer / ssd

SELECT username, email, COUNT(*) FROM users
GROUP BY username, email HAVING COUNT(*) > 1

Some times While checking MSGW for object / member / record locks ,I have seen it's locked by itself ...? How it happen and what action we need to perform if job is updating / writing a record....?

6 Answers   HSBC,

---

Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?

0 Answers  

---

Suppose you have 3 members in a database file. How to read records from all the members without using CL (OVRDBF) i.e. Entire process should be handled exclusively in a RPG program?

7 Answers  

---

what is the necessary command needed before OPNQRYF and why?

5 Answers  

---

What is the syntax of passing parameters to a procedure by value?

1 Answers  

---

what is the difference between the procedure and module in ILERPG?

4 Answers  

---

Have a join logical file with more than one members with different record formats. So how can we read the different members from this file and also how we can read the different record format from the join logical?

3 Answers  

---

how do I play {insert rpg system here}?

0 Answers   IBM,

---

How to print output from openquery in as400 ?

1 Answers   Four soft,

---

What is the Record Address file. How can we use it in RPG program?

4 Answers  

---

How to update selected fields from pf without using update opcode. How to read all member in Rpg-3,without using any cl command?

8 Answers  

---

I have 1000 records in a file. I would like to generate 10 identical reports from this record with same format (structure of records) how do I do this?

1 Answers   IBM,

---