How can the duplicate values be eliminated from db2 select?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

What is a LIKE table and how is it created?

2 Answers  


How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

0 Answers  


How to find schema of a table in db2?

0 Answers  


Once you create a view, where would information about the view be stored?

1 Answers  






is there any restrictions for unions ?

4 Answers   Patni,


pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,


Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  


What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,


What is a buffer pool?

2 Answers  


Where do you specify them?

0 Answers  


Is db2 a mainframe database?

0 Answers  


Categories