Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the number of duplicates in a file using Sort?
- 4 Answers
- 27284 Views
- Fidelity, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhijit saha
Hope this JCL explains your query
//COUNTDUP JOB ,'COUNT DUPLICT',
// MSGCLASS=Q,CLASS=D,
// NOTIFY=&SYSUID
//STEP010 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=ABCXYZ.UTIL.TEST,DISP=SHR
//RPT DD SYSOUT=*
//TOOLIN DD *
OCCUR FROM(IN) LIST(RPT) NOHEADER BLANK -
ON(1,2,CH) ON(VALCNT,U04)
/*
INPUT: ABCXYZ.UTIL.TEST
AB
AB
AB
DC
DC
PQ
PQ
Output:
AB 3
DC 2
PQ 2
| Is This Answer Correct ? | 17 Yes | 10 No |
Answer / prachi
In order to copy eliminated duplicates into another file
using sort is as below:
//SORTXSUM DD DSN=----
:
:
:
:
//SYSIN DD *
SORT FIELDS = copy
SUM FIELDS =NONE,XSUM
/*
//
| Is This Answer Correct ? | 7 Yes | 4 No |
Answer / divya reddy
we can sort it simply by using a command called" DF-sort"
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sudha
//
//
//
//sysin dd *
sort fields=(1,4,ch,a)
sum fields=none/all
/*
for avoiding duplicates
| Is This Answer Correct ? | 1 Yes | 2 No |
what is a MODELDSCB?
Define concatenating?
My JCL contains four steps //STP1 A(+1), DISP = NEW //STP2 A(+2), DISP = NEW //STP3 A(+3), DISP = NEW //STP4 A(+1), DISP = OLD STP3 was abended and I want restart my JCL from STP3 onwards & what are the precaution I want to take & what are the changes I need to make. Pls let me know.
Could anyone please suggest me what is the maximum length of data that can be pass as input in //sysin dd * This was asked in interview. TIA
What is primary allocation for a dataset?
Explain how can a stopped job be started again?
What is the error code SOC01 indicate ?
How does -818 sql error occur? Why does it happen and what can be done to overcome this error code?
How different is the JCL executing a COBOL program? 1) if the program is using VB file as input. 2) if the program is using FB file as input.
how can we merge two input files from two different jobs into one output file ? Please ans any one ASAP?
How can you trap abends in the JCL?
In a JCL if previous steps return code is greater than 0 or 4 then the next step will not execute. But the job will be successfull with the maximum return code. How can we reset this maximum return code to '0' regardless of return codes of any steps?
COBOL 
