View previous topic :: View next topic
|
Author |
Message |
mf_user Currently Banned New User
Joined: 05 Jan 2006 Posts: 47
|
|
|
|
Hi,
An UNION ALL is resulting in having the duplicate rows in a resultant table. The request is to process the duplicate rows also in the db2-cobol program.
How to achieve it?
TIA |
|
Back to top |
|
|
ragshere
New User
Joined: 20 Dec 2004 Posts: 70
|
|
|
|
Hi,
use UNION instead of UNION ALL . so that it won't give you duplicate rows .
Thanks
Rags |
|
Back to top |
|
|
|