Interested to Buy Any Domain ? << Click Here >> for more details...
How will you delete duplicate records from a table?
- 7 Answers
- 24780 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 host variable in db2 cobol?
Is db2 relational database?
is it compulsory commitment control in journal?
What is database reorganization?
What is nvl in db2?
What is an instance database?
How do I optimize a query in db2?
Explain what are the various isolation levels possible?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Is ibm db2 open source?
How to run db2 command in windows?
What is a db2 collection?
Which are the db2 tools to protect integrity of the database?
Explain how can you do the explain of a dynamic sql statement?
What is the connection string to connect to the DB2 Database ?
