Answer / ssd

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

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

4 Answers  

---

3 members in a databasefile .how to read records from all the members?????????

4 Answers   CTS,

---

In a particular program one file is used where override command is applied to a file, now this program calls another program where we want to use the same file but without override.How it can be done?

6 Answers   Hexaware,

---

How to sort an array in descending in RPG

3 Answers   Google, TCS,

---

How can we find out whether the job is interactive or Batch through RPG program? 2) How can we find out through CL program?

6 Answers   CSC,

---

parameters cannot be passed in which one???

4 Answers   CTS,

---

RPG/400 faqs?

1 Answers   HSBC,

---

1.String operatio such as moving the characters to the variables? 2.what are the building functions for check file longs? 3.which of the following methods will make externally describe file fields available to a program? A: A/copy statement that specifies the library file and member of the field reference file source code B: A data structure definition specification that names the file on the EXTNAME keyword C: A data structure definition specification that names the file on the IMPORT keyword? D: A Definition specification for each desired field with the REFFLD keyword

1 Answers   CSC, CTS,

---

You have a *USE authority on a Library and *All authority on a file in that Library.Can you change the data in that file?

1 Answers  

---

what is estimation? and what is the level identifier parameter in PF?

3 Answers   TCS,

---

how to retrieve RRN value in RPGLE program

3 Answers  

---

If I have a file with 5 record and that file has 2 Key field and I want to read the unique record of the file then how can we achieve it?

1 Answers  

---