Hi,
The below JCL is including only the records I want but it does not only
select the first duplicate.
//SORT EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DISP=SHR,DSN=INPUT.FILE
//T1 DD DSN=&&T1,DISP=(MOD,PASS),SPACE=(TRK,(5,5))
//OUT DD SYSOUT=*
//OUTFIL DD SYSOUT=*
//TOOLIN DD *
SELECT FROM(IN) TO(OUT) ON(1,134,CH) USING(CTL1) FIRST
/*
//CTL1CNTL DD *
OPTION COPY
INCLUDE COND=((4,7,CH,EQ,C'NETWORK',OR,
59,1,CH,EQ,C'.'),AND,
(3,5,CH,NE,C'TOTAL',AND,
3,5,CH,NE,C'GRAND'))
/*
If I change the include to only select the records with NETWORK then the
OUT DD only has 1 record unlike the first example that has 13 of the
same record
//CTL1CNTL DD *
OPTION COPY
INCLUDE COND=((4,7,CH,EQ,C'NETWORK'))
/*
I can't figure out what the difference is that causes the other
conditions to change it so it has duplicates
I tried a doing this a few different ways like the below by doing the
includes in the first select and then just a copy with a SELECT FIRST
but the result is the same I have duplicate records.
//TOOLIN DD *
SELECT FROM(IN) TO(T1) ON(1,133,CH) USING(CTL1) FIRST
SELECT FROM(T1) TO(OUT) ON(1,133,CH) USING(CTL2) FIRST
/*
//CTL1CNTL DD *
OPTION COPY
INCLUDE COND=((4,7,CH,EQ,C'NETWORK',OR,
59,1,CH,EQ,C'.'),AND,
(3,5,CH,NE,C'TOTAL',AND,
3,5,CH,NE,C'GRAND'))
/*
//CTL2CNTL DD *
OPTION COPY
/*
Thanks
James
--
This is a confidential communication and is intended only for the addressee
indicated in the message (or duly authorised to be responsible for the delivery
of the message to such person). You are specifically prohibited from copying
this message or delivering the same, or any part thereof, to any other person,
whomsoever or howsoever, unless you receive written authorisation from us to
do.
If you are anyone other than the intended addressee, or person duly authorised
and responsible for the delivery of this message to the intended addressee, you
should destroy this message and notify us immediately.
Please note that we accept no responsibility whatsoever in the event that this
message or any other email message or any part thereof becomes known or is
communicated to anyone other than the intended recipient or other person
authorised in writing by us to receive it, howsoever arising and disclaim all
liability for any losses or damage which may be sustained by any person as a
result thereof.
Irish Life Assurance plc is regulated by the Central Bank of Ireland.
Irish Life Financial Services Limited is regulated by the Central Bank of
Ireland.
"Irish Life" is a member of the Irish Life and Permanent plc group. Irish Life
Assurance plc is a company registered in Ireland. Registered office is situated
at Irish Life Centre, Lower Abbey Street, Dublin 1. Registered Number 152576.
Irish Life Financial Services Limited is a company registered in Ireland.
Registered office is situated at Irish Life Centre, Lower Abbey Street, Dublin
1. Registered Number 489221.
==============================================================================
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
