IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to process duplicate rows of UNION ALL programatically?
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
mf_user
Currently Banned
New User


Joined: 05 Jan 2006
Posts: 47
PostPosted: Mon Mar 06, 2006 8:14 pm
 Reply with quote
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 icon_smile.gif
Back to top
View user's profile Send private message
ragshere

New User


Joined: 20 Dec 2004
Posts: 70
PostPosted: Tue Mar 07, 2006 6:57 pm
 Reply with quote
Hi,
use UNION instead of UNION ALL . so that it won't give you duplicate rows .



Thanks
Rags
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Similar Topics
Topic Forum Replies
No new posts To get the count of rows for every 1 ... DB2 3
No new posts Duplicate transid's declared using CEDA CICS 3
No new posts Exclude rows with > than x occurre... DFSORT/ICETOOL 6
No new posts Duplicate several members of/in one l... JCL & VSAM 7
No new posts Convert single row multi cols to sing... DFSORT/ICETOOL 6
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us