How will you delete duplicate records from a table?
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
can we view the access paths created by dbrm ? how ? thx
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Outputs of explain are with matchcols = 0. What does this signify?
What is the cobol picture clause of the db2 data types date, time, timestamp?
List out the three types of page locks that can be held.
How many databases are there?
What are the rules for db2 programming?
What is coalesce in db2?
How would you find out the total number of rows in a db2 table?
List down the types of triggers in the db2 database?
How can deadlocks be resolved?
What is explain plan in db2?
What is the difference between plan and package in db2?
What is buffer pool and list some of them?
What are packages in db2?