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

Answer Posted / dhan

DFSORT is one of the IBM product. It is a program you use to sort,
merge, and copy the data from one file to another file.

https://youtu.be/IPDyz2xl7Tk
https://youtu.be/9311_rE9LE8
https://youtu.be/HFT9wXtoo74

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the resolution for sb37 error

8401


WORKING-STORAGE SECTION. 01 GROSS-PAY. 05 BASIC-PAY PIC 9(5). 05 ALLOWENCES PIC 9(3). PROCEDURE DIVISION. MOVE 1000 TO BASIC-PAY. MOVE 250 TO ALLOWENCES. DISPLAY GROSS-PAY. STOP RUN. 77 W-A PIC 9(3)V99 VALUE 23.75 77 W-B PIC ZZ9V99 VLAUE 123.45 after the statement MOVE W-A TO W-B what will be W-B's value? a.123.75 b.b23.75 (where b indicates space) c.023.75 d.invalid move

1091


what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?

945


How is the record format of an output dataset specified?

992


In sms datasets, what is the function of the dd avgrec keyword?

863


1) SORT FIELDS=(20,4,CH,D,10,3,CH,D) OUTREC FIELDS=(7:20,4,C' FUTURE ',20,2,10,3,1Z,1,9,13,7, 24,57,TRAN=LTOU,6X'FF') This example illustrates how a fixed-length input data set can be sorted and reformatted for output. The SORTIN LRECL is 80 bytes. The reformatted output records are fixed length with a record size of 103 bytes. SOLRF (the IBM-supplied default) is in effect, so unless the SORTOUT LRECL is specified or available, it will automatically be set to the reformatted record length of 103. in the above example i have some doubts that a) sort fields=(20,4,CH,D,10,3,CH,D) -what exactly it does and this fields related to output record fields or input record fields b)outrec used to refprmat the records after sorting that means could please reply me as soon as possible Thanks. Venkat

7430


Is their any limit for data sets?

901


Brief description of inline procedure of jcl.

923


What are the jcl procedures?

863


What is the function of a dd statement?

940


Are there any set of rules for the names of the steps used in a job?

874


how can the same proc be re-used and called by many jobs?

1202


what happens in execution stage in job processing?

863


What statement can be used to send data to another mvs jes3 node?

1299


Can we use DISP=SHR in output file in JCL

1191