Hi All, Thanks for your feedback about the error. To add more about the functionality of the jcl, here is what I am trying to do.
1. There is a common field between files IN1 and IN2. It's position in
both files is from 4 and its length is 12.
2. I want to take 4 fields from file IN1 and one field from file IN2 and place
those in output file "OUT". In the output file. first field is the key (4,12).
Then 4 char acct code, 6 character date (this comes from IN2), this is
followed by two more fields at position 105 and 197 in file IN1. The
following control card shows the sequence, position and length of the field
Can I put it in the SORT and ICETOOL forum so that we can have views from the experts on ICETOOL? If someone can let me know how I can transfer or copy this to another forum that will be nice.
Joined: 26 Apr 2004 Posts: 4650 Location: Raleigh, NC, USA
Can I put it in the SORT and ICETOOL forum so that we can have views from the experts on ICETOOL?
No, you can't. Alissa Margulies is the SYNCSORT/SYNCTOOL product expert, and since you're paying for their support, then you need to use that resource. I'm sure she'll respond to your post if she feels that it's necessary. Otherwise, you always have the option of direct communications with their customer service department.
I have tried the SYNCTOOL to extract fields from two files based on a key. I got the abend as follows. Any pointer to solve the error will be appreciated.
SYSTEM COMPLETION CODE=013 REASON CODE=00000034
NO ACTIVE MODULE FOUND
Please email me the complete and unedited job listing (including the JES Job Log, JCL and SYSOUT messages) as a text attachment and I would be happy to assist you further. You can send it to firstname.lastname@example.org.
I reviewed the job listing from an actual run. It appears that the * was missing from both CTLnCNTL DD statements. SMS was allocating a dataset for CTL1CNTL with no or incorrect DCB attributes. I pointed this out to Manohar and he is going to modify the JCL and rerun the job.
Joined: 23 Nov 2006 Posts: 19254 Location: Inside the Matrix
Good to hear it is working and thank you for the update
As a caution going forward, it is very important that jcl and control statements be posted using copy/paste rather than re-keying.
It is also quite helpful if jcl, code/control info, and data are posted using the "Code" tag near the top of the Reply panel.
The "Preview" can be used to see how the post will appear to the forum rather than the way it appears in the reply editor. When the post appears as desired, click Submit (if Submit is not clicked, the post will be lost - i've done that . . . )