Interested to Buy Any Domain ? << Click Here >> for more details...
How will you delete duplicate records from a table?
- 7 Answers
- 24826 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / ajay kumar ande
question is wrong......records-----files,table-----rows
How will you delete duplicate records(rows) from a table?
pgm=sort
sortin dd dsn=-----
sortout dd dsn=-----
sysin dd *
sort fields=(2,3,ch,a)
sum fields=none ------>eliminates duplicate recs
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is cursor stability in db2?
What is db2 command?
How do you find the maximum value in a column in db2?
What is access path in db2?
What is deadlock in db2?
What is view db2?
How do I import a csv file into db2?
What is multi row fetch in db2?
What is the difference between using bind () and rebind () methods of naming class?
Give a brief description of db2 isolation levels?
Are view updateable?
What is with ur in db2?
What is dclgen (declaration generator)?
How can we read records for specific member in CL? AND rpg?
What is db2 plan table?
