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
//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 /*
Which statement is used to identify the private libraries in job?
List the different components of jcl statement?
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) ?
how JCL works?
what is use of space parameter in dd statement?
I need exexution process for JCL programs
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
how can you check if a file is empty using jcl?
List the various advantages of using jcl language?
What is the function of the dd dcb keyword?
How do you overcome this limitation ?
Explain how can an in-stream dataset be terminated?
Explain about LMQUERY�give a dialog information about a data set
Is it possible to left uncode disp? If yes, how?