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

Answer Posted / sanjeeva reddy

Sort: Sort utility is used to sort the data in particular order(Ascending or Descending order).

Eliminate Duplicate Records:
----------------------------
//SYSIN DD *
SORT FIELDS=COPY
SUM FIELDS=NONE
/*
Select Some Records:
--------------------
You can use "INCLUDE CODITION" along with "SORT FIELDS" to
select desired records.The code goes like this......

//SYSIN DD *
SORT FIELDS=(<Give The Sort Condition Here>)
INCLUDE COND=(<Give The Required Condition Here>)
/*

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

//S10 EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //CON DD DSN=VAR.INPUT1,DISP=SHR // DD DSN=VAR.INPUT2,DISP=SHR //OUT DD DSN=VAR.OUTPUT,DISP=(NEW,CATLG,DELETE), // SPACE=(CYL,(5,5)),UNIT=SYSDA //TOOLIN DD * * Splice the needed data from the two VB files together SPLICE FROM(CON) TO(OUT) ON(5,5,CH) WITHALL - WITH(12,5) WITH(22,20) VLENMAX /*

916


Which statement is used to identify the private libraries in job?

680


List the different components of jcl statement?

698


We can use PASS with permanent datasets also. THEN Which is the condition in which we may use PASS (instead of KEEP) with permanent data sets, while there is no need to specify UNIT and VOL for them like temporary data sets (in cas we use KEEP for permanent data sets) ?

1773


how JCL works?

800






what is use of space parameter in dd statement?

758


I need exexution process for JCL programs

1854


How to remove the spaces at end of each record in the output file Via COBOL program? note: The file has a VB length ----TRY

862


how can you check if a file is empty using jcl?

816


List the various advantages of using jcl language?

854


What is the function of the dd dcb keyword?

832


How do you overcome this limitation ?

700


Explain how can an in-stream dataset be terminated?

704


Explain about LMQUERY�give a dialog information about a data set

906


Is it possible to left uncode disp? If yes, how?

708