|
View previous topic :: View next topic
|
| Author |
Message |
rahul.banik
New User
.jpg)
Joined: 23 Jan 2007
Posts: 16
Location: Mysore
|
|
|
|
Hi All,
I've one input file as below. In this file SD00-DISC-SEQ has duplicate value.
| Code: |
SD00-DISC-SEQ
3/NUM
(27-29)
10-----------
**************
601
602
602
603
604
604
604
605
606
607 |
I want only those records which has duplicate value.
Expected output would be as below.
| Code: |
SD00-DISC-SEQ
3/NUM
(27-29)
10-----------
**************
602
602
604
604
604
|
SUM FIELDS=NONE,XSUM is to write the duplicate records into separate file. I want these duplicate record also the unique record into same file.
i'm using SYNCSORT FOR Z/OS 1.3.1
Thank,
RB |
|
| Back to top |
|
 |
ramsri
Active User
Joined: 18 Oct 2008
Posts: 380
Location: India
|
|
|
|
Hi,
This should help you.
| Code: |
//STEP0001 EXEC PGM=SYNCTOOL
//TOOLMSG DD SYSOUT=*
//SSMSG DD SYSOUT=*
//IN1 DD *
601
602
602
603
604
604
604
605
606
607
//OUT1 DD SYSOUT=*
//TOOLIN DD *
SELECT FROM(IN1) TO(OUT1) ON(11,3,ZD) ALLDUPS
/*
|
Thanks. |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
|
|
rahul.banik,
For your requirement you might need to modify the SELECT statement in the job provided by ramsri like this.
| Code: |
//TOOLIN DD *
SELECT FROM(IN1) TO(OUT1) ON(11,3,ZD) ALLDUPS
|
AS
| Code: |
//TOOLIN DD *
SELECT FROM(IN1) TO(OUT1) ON(27,3,CH) ALLDUPS
|
|
|
| Back to top |
|
|
ramsri
Active User
Joined: 18 Oct 2008
Posts: 380
Location: India
|
|
|
|
Nice observation Arun  |
|
| Back to top |
|
|
rahul.banik
New User
Joined: 23 Jan 2007
Posts: 16
Location: Mysore
|
|
|
|
Hi All,
Thanks for quick reply.
I've one question.
How to add multiple sort condition into ON operand?
I'm using following sort card but I got this error.
Sort card:
| Code: |
//TOOLIN DD *
SELECT FROM(SORTIN) TO(SORTOUT) ON(3,8,ZD,11,4,ZD,15,4,ZD,19,5,ZD,
24,2,ZD,26,1,CH,27,3,ZD) ALLDUPS
/* |
Error :
| Code: |
SYNCTOOL RELEASE 1.6.1 - COPYRIGHT 2007 SYNCSORT INC.
INITIAL PROCESSING MODE IS "STOP"
"TOOLIN" INTERFACE BEING USED
SELECT FROM(SORTIN) TO(SORTOUT) ON(3,8,ZD,11,4,ZD,15,4,ZD,19,5,ZD,
INVALID "ON" OPERAND
OPERATION COMPLETED WITH RETURN CODE 12
PROCESSING MODE CHANGED FROM "STOP" TO "SCAN" DUE TO OPERATION FAILURE
24,2,ZD,26,1,CH,27,3,ZD) ALLDUPS
STATEMENT DOES NOT BEGIN WITH A VALID OPERATOR
SYNCTOOL PROCESSING COMPLETED WITH RETURN CODE 12 |
|
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
|
|
| Quote: |
| How to add multiple sort condition into ON operand? |
rahul.banik,
You need to use multiple 'ON' conditions like this.
| Code: |
| ON(p1,l1,f1) ON(p2,l2,f2) ON(p3,l3,f3) |
|
|
| Back to top |
|
|
rahul.banik
New User
Joined: 23 Jan 2007
Posts: 16
Location: Mysore
|
|
|
|
Thanks everyone..
It's working fine.
 |
|
| Back to top |
|
|
|
|
|
