Answer / ssd

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

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,

---

where we give the MSGSFL in rpg400?

4 Answers  

---

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

4 Answers   CTS,

---

what is data area and how it is used in rpg program ?

0 Answers   IBM,

---

1.Can any body share me about thease opcodes with example please.Im new for AS/400.Could u please tell me in real senario? 1.TESTN, 2.EVAL 3.EVALR, TIME, 4.MONITOR 5. ENDMON 6.ON-ERROR 7.COMMIT ROLLBACK?

1 Answers   CSC,

---

in which journalling which attributes are necessary

2 Answers   CTS,

---

Hi guys, anybody know How RPG/400 code can be converted to RPG IV code with a single command?

1 Answers  

---

what is the procedure and explain about real time scenario.

0 Answers   Adhoc Technologies, Hanuman Automation, HSBC, IBM,

---

If my rpg program has a date field, what extra care I have to take while compiling that rpg program? If the file is keyed and I have declared the file as well as key list properly in my program. Still am getting an error message like "chain/reade operation is not allowed" what may be the case?

0 Answers  

---

How to find d key field of a pf that doesn’t have source physical file?

2 Answers  

---

How can we override a file during runtime in RPG? Without using OVRDBF or calling a CL program

1 Answers   UST,

---

which MONMSG will give higher priority in CL program? I know MONMSG are of two types. Program Level Monmsg and Command Monmsg?

1 Answers  

---