How will you delete duplicate records from a table?
- 7 Answers
- 23753 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 a db2 tablespace?
How does a cursor work?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is image copy in db2?
How to create db2 table in mainframe?
What is db2 bind process?
How do you stop a db2 database in linux?
How do I add a column in db2?
What is dbrm? What it contains?
Explain in detail about buffer manager and its functionalities?
What is the reason behind not using select * in embedded sql programs?
What is with ur in db2?
What is load utility in db2?
What are the prerogatives?
What is the physical storage length of time data type?
