Why are you trying to do all such things (keeping your other recent post in mind) using ICEgener when you've other, rather appropriate, utilities available to you.
You should keep in mind, ICEGENER is used to achieve more efficient processing for applications set up to use the IEBGENER system utility, it is not meant to replace the application written for sort/icetool. Also, JOINKEYS is a feacture which was introduced to enhance DFSORT and DFSORT's ICETOOL applications, it is not supposed to be used with ICEGENER right-away, the way you asked for. _________________ Regards,
Anuj
However, you might experiment with that and it might work, as ICEGENER internally invokes SORT in the background (I just learnt it) and you should be able to do what you might be looking for. Let's wait for the representative of this product, they will be having a better answer; lets' hope for the best. _________________ Regards,
Anuj
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Wed May 12, 2010 12:14 pm Post subject:
MF,
My first question would be - why do you want to use ICEGENER for a JOINKEYS operation instead of using DFSORT or ICETOOL directly? _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Posted: Wed May 12, 2010 10:35 pm Post subject: COPY
Frank,
I tried several SORT statements (WHEN=GROUP, INCLUDE, INREC, OUTFIL etc) things with ICEGENER and got successful results. So, I tried my hand at using JOINKEYS but it did not click. It was a question out of curiosity.
Thanks. _________________ MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==
Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
Posted: Thu May 13, 2010 1:01 pm Post subject: Re: COPY
mf_user wrote:
Frank,
I tried several SORT statements (WHEN=GROUP, INCLUDE, INREC, OUTFIL etc) things with ICEGENER and got successful results. So, I tried my hand at using JOINKEYS but it did not click. It was a question out of curiosity.
Thanks.
Mfuser,
I am not sure what you tried, but you can make joinkeys work with DFSORT'S ICEGENER. Here is a sample jcl
Code:
//STEP0100 EXEC PGM=ICEGENER
//SYSPRINT DD SYSOUT=*
//INP1 DD *
Z
D
A
C
//INP2 DD *
C MATCH VALUE2
A MATCH VALUE1
//SYSUT2 DD SYSOUT=*
//DFSPARM DD *
JOINKEYS F1=INP1,FIELDS=(1,1,A)
JOINKEYS F2=INP2,FIELDS=(1,1,A)
SORT FIELDS=COPY
REFORMAT FIELDS=(F1:1,3,F2:4,15)
//SYSIN DD DUMMY
//*
Thanks a lot. There was one problem. Job was expecting SYSUT1. So, I supplied it and it worked fine.
Thanks once again. _________________ MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Thu May 13, 2010 2:29 pm Post subject:
Quote:
There was one problem. Job was expecting SYSUT1. So, I supplied it and it worked fine.
Just for closure, please show the job you used that didn't work, and the job you used with SYSUT1 that did work, and I'll explain how to change your job so it doesn't expect SYSUT1. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Thu May 13, 2010 2:32 pm Post subject:
Trivia: Note that in Kolusu's ICEGENER job, we actually don't need SORT FIELDS=COPY because ICEGENER automatically supplies OPTION COPY. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Posted: Fri May 14, 2010 4:18 am Post subject: to Frank
Hi,
Job that worked:
Code:
//STEP0100 EXEC PGM=ICEGENER
//SYSUT1 DD *
//SYSPRINT DD SYSOUT=*
//INP1 DD *
Z
D
A
C
//INP2 DD *
C MATCH VALUE2
A MATCH VALUE1
//SYSUT2 DD SYSOUT=*
//DFSPARM DD *
JOINKEYS F1=INP1,FIELDS=(1,1,A)
JOINKEYS F2=INP2,FIELDS=(1,1,A)
SORT FIELDS=COPY
REFORMAT FIELDS=(F1:1,3,F2:4,15)
//SYSIN DD DUMMY
//*
Job that DID NOT work:
Code:
//STEP0100 EXEC PGM=ICEGENER
//SYSPRINT DD SYSOUT=*
//INP1 DD *
Z
D
A
C
//INP2 DD *
C MATCH VALUE2
A MATCH VALUE1
//SYSUT2 DD SYSOUT=*
//DFSPARM DD *
JOINKEYS F1=INP1,FIELDS=(1,1,A)
JOINKEYS F2=INP2,FIELDS=(1,1,A)
SORT FIELDS=COPY
REFORMAT FIELDS=(F1:1,3,F2:4,15)
//SYSIN DD DUMMY
//*
Error Message:
Code:
DDNAME SYSUT1 CANNOT BE OPENED
Thanks. _________________ MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Fri May 14, 2010 12:08 pm Post subject:
Quote:
Job that DID NOT work:
...
Error Message:
DDNAME SYSUT1 CANNOT BE OPENED
That job works fine with DFSORT's ICEGENER. That message is NOT a DFSORT message, so I can only assume that you're using Syncsort, not DFSORT, and while the job works with DFSORT (ICExxxs messages), it does NOT work with Syncsort (WERxxxs messages). _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
