|
View previous topic :: View next topic
|
| Author |
Message |
manoopatil
New User
Joined: 07 Dec 2003
Posts: 56
Location: Montreal
|
|
|
|
Hi,
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
NAME=UNKNOWN.
Following is the step for the SORT.
| Code: |
//FORMAS EXEC PGM=SYNCTOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN1 DD DSN=TSOR.WWW.XAUTO.XPD.ICE1,DISP=SHR
//IN2 DD DSN=TSOR.WWW.XAUTO.DAT.ICE1,DISP=SHR
//T1 DD DSN=&&T1,UNIT=TSO,SPACE=(TRK,(10,20)),
// DISP=(MOD,PASS)
//OUT DD DSN=TSOR.WWW.XAUTO.WEBMAST,
// UNIT=TSO,
// DISP=(,CATLG,DELETE),
// SPACE=(CYL,(10,50),RLSE)
//TOOLIN DD *
COPY FROM(IN1) TO(T1) USING(CTL1)
COPY FROM(IN2) TO(T1) USING(CTL2)
SPLICE FROM(T1) TO(OUT) ON(4,12,CH) WITH(17,6)
/*
//CTL1CNTL DD *
* USE OUTREC TO CREATE |KEY |F1FLD |BLANK|
OUTREC FIELDS=(1:4,12,13:75,4,17:6X,23:105,6,29:197,7)
/*
//CTL2CNTL DD *
* USE OUTREC TO CREATE:|KEY |BLANK |F2FLD|
OUTREC FIELDS=(1:4,12,17:26,6)
/*
//*
|
Error Messages :-
IEC141I 013-34,IGG0191I,WEBSPLT,FORMAS,CTL1CNTL,VIO , ,SYS08245.T220930.RA0
WER999A WEBSPLT ,FORMAS , - UNSUCCESSFUL SORT 013 S REASON=00000034
IEA995I SYMPTOM DUMP OUTPUT
SYSTEM COMPLETION CODE=013 REASON CODE=00000034
TIME=22.09.31 SEQ=04170 CPU=0000 ASID=01A5
PSW AT TIME OF ERROR 075C1000 80E5CCC6 ILC 2 INTC 0D
NO ACTIVE MODULE FOUND
NAME=UNKNOWN
IEF472I WEBSPLT FORMAS - COMPLETION CODE - SYSTEM=013 USER=0000 REASON=00000034
SYT000I SYNCTOOL RELEASE 1.5.2 - COPYRIGHT 2004 SYNCSORT INC.
SYT001I INITIAL PROCESSING MODE IS "STOP"
SYT002I "TOOLIN" INTERFACE BEING USED
COPY FROM(IN1) TO(T1) USING(CTL1)
SYT020I SYNCSORT CALLED WITH IDENTIFIER "0001"
Thanks
Manohar |
|
| Back to top |
|
 |
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
|
|
Your problem seems to be with the CTL1CNTL DD statement:
IEC141I 013-34,IGG0191I,WEBSPLT,FORMAS,CTL1CNTL,VIO , ,SYS08245.T220930.RA0
3.69 IEC141I. |
|
| Back to top |
|
|
charanmsrit
New User
Joined: 25 Oct 2007
Posts: 81
Location: Australia
|
|
|
|
| system RC 013 is usually missing input dataset. please check whether your input files exist |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| charanmsrit wrote: |
| system RC 013 is usually missing input dataset. please check whether your input files exist |
Methinks that would more likely cause a JCL error - don't you ? |
|
| Back to top |
|
|
manoopatil
New User
Joined: 07 Dec 2003
Posts: 56
Location: Montreal
|
|
|
|
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
=(1:4,12,13:75,4,17:6X,23:105,6,29:197,7)
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.
Thanks
Manohar |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2482
Location: @my desk
|
|
|
|
Manohar,
| Code: |
//CTL1CNTL DD *
* USE OUTREC TO CREATE |KEY |F1FLD |BLANK|
OUTREC FIELDS=(1:4,12,13:75,4,17:6X,23:105,6,29:197,7)
/*
//CTL2CNTL DD *
* USE OUTREC TO CREATE:|KEY |BLANK |F2FLD|
OUTREC FIELDS=(1:4,12,17:26,6)
/* |
Here in CTL2CNTL, you need to fill the rest of the record with spaces to make it the same length as that you got from CTL1CNTL
I think CTL2CNTL should be something like this.
| Code: |
| OUTREC FIELDS=(1:4,12,17:26,6,23:13X) |
Thanks,
Arun |
|
| Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
|
|
| manoopatil wrote: |
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. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| Can I put it in the SORT and ICETOOL forum |
No.
Your question uses Syncsort and will remain in this part of the forum.
If Syncsort questions are posted in the DFSORT part of the forum, they are moved to this part of the forum. That part of the forum is only for the IBM product.
Have you gotten by the 013 abend? |
|
| Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007
Posts: 496
Location: USA
|
|
|
|
| manoopatil wrote: |
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
NAME=UNKNOWN. |
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 [email protected]. |
|
| Back to top |
|
|
manoopatil
New User
Joined: 07 Dec 2003
Posts: 56
Location: Montreal
|
|
|
|
Hi All,
Thank you so much for sharing your views/feedback.
I have sent the job details and output to Alissa from syncsort.
Arun, I tried to submit JCL incorporating your suggestion. But the error S0013 still remained.
I will keep everyone posted. Any comments/suggestions are always welcome
Thanks
-Manohar |
|
| Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007
Posts: 496
Location: USA
|
|
|
|
| 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. |
|
| Back to top |
|
|
manoopatil
New User
Joined: 07 Dec 2003
Posts: 56
Location: Montreal
|
|
|
|
Hi All,
The job ran to success with Alissa's suggestion.
Thanks everybody!
Manohar |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello Manohar,
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 . . .  ) |
|
| Back to top |
|
|
|
|
  |
All times are GMT + 6 Hours |
|
