GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  Mainframe
Go To First  |  Previous Question  |  Next Question 
 Mainframe  |  Question 35 of 65    Print  
Sort Duplicates in Dataset
How do I use SORT to copy duplicates in a Dataset to another


  
Total Answers and Comments: 1 Last Update: April 16, 2008     Asked by: Mainframeguy 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
April 16, 2008 09:47:35   #1  
Mainframeguy Member Since: March 2008   Contribution: 5    

RE: Sort Duplicates in Dataset
Use XSUM parameter in Sort

Syntax for XSUM - SUM FIELDS=NONE,XSUM in the Sort card, and a DDNAME SORTXSUM to define the file for XSUM.

 
Is this answer useful? Yes | No

 Related Questions

When calculating the record size for Alternate index(with duplicates) we use ==> AIX LENGTH+ 5 + ( n * PRIMARY KEY LENGTH ) Here "n" is the no.of duplicates we want to have. I don't understand this "n" .. how can we decide that no. of duplicates???

Latest Answer : If the data is in a specific position in the records, use the sort INCLUDE statement to select the records.//SORTSEL EXEC PGM=SORT//SYSOUT     DD  SYSOUT=*//SORTIN     DD  DSN=INPUT.FILE,DISP=OLD//SORTOUT  DD  ...
Read Answers (1) | Asked by : ANILSAYA

How do I use SORT to copy duplicates in a Dataset to another 
Latest Answer : Use XSUM parameter in SortSyntax for XSUM - SUM FIELDS=NONE,XSUM in the Sort card, and a DDNAME SORTXSUM to define the file for XSUM. ...

How to get the mismatch data in dataset during comprision of two datasets of different length? 
Latest Answer : We have to write JCL by using 'IEBCOMPR'.FOR Sequential data set//COMPSEQ EXEC PGM=IEBCOMPR//SYSPRINT  DD SYSOUT=*//SYSUT1     DD DSN=,DISP=SHR//SYSUT2     DD DSN=,DISP=SHR//SYSIN        ...


 Sponsored Links

 
Related Articles

ODP.NET - Presenting Master-Detail Information Using a Dataset

ODP NET Presenting Master Detail Information Using a Dataset As mentioned before a DataSet object can have its own relations between data tables existing in it We can add these relations dynamically at the client side within an application to represent master detail or hierarchical information The f
 

ODP.NET - Populating a Dataset with a Single Data Table

ODP NET Populating a Dataset with a Single Data Table A dataset is simply a group of data tables These data tables can be identified with their own unique names within a dataset You can also add relations between data tables available in a dataset mosgoogle The following code gives you the details o
 

jQuery - Finessing the Sort Key

Learning jQuery Finessing the Sort Keys Now we want to apply the same kind of sorting behavior to the Author s column of our table By adding the sort alpha class to its table header cell the Author s column can be sorted with our existing code But ideally authors should be sorted by last name not fi
 

Mainframe Features

Mainframe Features In this Mainframe tutorial you will learn about features of Mainframe Processing power memory capacity performance computing multiple operating system time sharing reliability serviceability availability clustering technology and other features available in Mainframe mosgoogle cen
 

Mainframe Assembler Ebooks and Manuals

Please find 267 mainframe Assembler ebooks and Manuals mosgoogle center High Level Assembler for MVS VM VSE V1R2 0 HLASM V1R2 0 General Information GIM for MVS VM High Level Assembler for MVS V Category Mainframe
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape