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

Diff between union and unionall
IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
hainamash

New User


Joined: 09 Oct 2006
Posts: 4
Location: chennai
PostPosted: Mon Nov 20, 2006 5:10 pm
 Reply with quote
can anybody tell me diff between union and unionall (min 2 diff)
i known unionall retrieve duplicates record,union retrieve no duplicates
Back to top
View user's profile Send private message
MFRASHEED

Active User


Joined: 14 Jun 2005
Posts: 186
Location: USA
PostPosted: Mon Nov 20, 2006 11:11 pm
 Reply with quote
Refer to manual

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnsqj10/4.3?ACTION=MATCHES&REQUEST=UNION+ALL&TYPE=FUZZY&SHELF=&DT=20040216135741&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT
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 -> Mainframe Interview Questions

 

Similar Topics
Topic Forum Replies
No new posts Sort on different fields, removing du... SYNCSORT 8
No new posts How syntax check at Bind time is diff... DB2 5
No new posts Illegal use of keyword fetch. Token w... DB2 2
No new posts Compare PD Values with same storage &... JCL & VSAM 5
No new posts merge records from 2 ps files with di... 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