Answer Posted / chiranjeevi ch

let us assume we have some duplicate records in sample table
and we can identify duplicates with eid.

The the query looks like this.

Select * from sample
where eid=any
(select eid from sample having count(eid)>1 group by eid);

Note: This should be used SQl .. but i never tried in as400
when ever it is necessary means i use following sql
statement in as400 .......

select * from sample where eid=111

it displays all duplicate records related to 111

How to call one program from another program in RPG? please help me with the code

1683

---

Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.

2476

---

what do you mean by an input subfile, what are the keywords required?

1208

---

can you debug ile rpg program using isdb?

1196

---

What is a record lock error?

1711

---

what is program status data structure?

2301

---

what was the robotech rpg?

1143

---

When it is desirable to describe files Internally?

1665

---

how do you use commitment control in rpg?

1236

---

what is *place and *auto keyword in prtf ?plz explain

3105

---

We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?

1216

---

What is the purpose of record level identifier?

1088

---

what is the difference between do while and do until?

1199

---

How Chain operation copies the record's data to the input buffer for the program?

1555

---

thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400

2281

---