What is SORT ? How do we eliminate duplicate records ? How
do I select some records using SORT ?

Answer Posted / prashanth

---sort is a sorting of records either in asc/ des order,
---sort field(6,10,ch,ASC) or sort field(6,10,ch,ASC),equal
sum field none
---sort field(6,10,ch,Asc) 6 is the starting position
10 record length
ch for alpnum (X)
asc order of sorting

Is This Answer Correct ?    14 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to resolve the error "WER488A JOIN CAPACITY EXCEEDED" I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem? I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem?

7613


if the submitter of a job wants to inform another user about the job completion, how can it be done?

758


How to do automated restart when a job abend?

791


Explain how can return codes be tested before execution of a job step?

834


Explain the function of the dd dcb keyword?

706






what is DSN parameter and DISP parameter is used for?

680


What do you understand by the term job time – out and how can you overcome that?

608


what is use of space parameter in dd statement?

758


I have mainpgm(abc) this is the only cobol pgm(non-db2).And this pgm calling subpgm name "acd" this also only cobol(non- Db)and this pgm calling some other subpgm this pgm has cobol-db2 pgm. 1) IF you calling static mode how to run and how to compile? 2) IF you calling dynamic mode how to run and how to compile? plz suggestion me.

1956


How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.

5064


How to read and write a single record into a file. I would like to use it to enter a single 8-character piece of information and use it to put it into a variable for processing in JCL. Thank you

610


How to submit a jcl from cics?

670


What is the purpose of disp parameter?

647


Explain the jcl exec statement?

652


I have a COBOL program that ACCEPTs some input data. How do you code the JCL statement for this?

704