Joined: 23 Apr 2007 Posts: 50 Location: Jefferson City, Mo
One other question what caused the extra spaces in the name Steverson
Maxine C Steverson The last name is up against the middle initial and then there are extra spaces in the last name...
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
ScottUrban,
Please RUN your JOB with your actual Data instead if the test data in here. You reformatting the data on the OUTREC using specific positions. So You are just picking from the input layout.
The OUTREC is NOT coded by me but you coded it , so you should be able answer the question yourself rather than asking me , because I just used your control cards and showed you a way to add the desired header.
Joined: 23 Apr 2007 Posts: 50 Location: Jefferson City, Mo
kolusu,
Sorry to bother you again.
I need to set these statements up so they are not instream. Using a sysin library. I have created 2 members one named Toolin with the SPLICE statements and one called CTL1 with the CTL1CNTL statements. My JCL is below and I am receiving an error.
***************************** Top of Data ***********************
SPLICE FROM(IN) TO(OUT) ON(106,8,CH) KEEPNODUPS WITHALL -
WITH(1,105) KEEPBASE USING(CTL1)
**************************** Bottom of Data *********************
CONTENTS OF CTL1
Statements start in column 5
***************************** Top of Data ******************************
INREC IFTHEN=(WHEN=INIT,OVERLAY=(106:SEQNUM,8,ZD)),
IFTHEN=(WHEN=(31,1,CH,EQ,C'#'),OVERLAY=(106:SEQNUM,8,ZD,1,30)),
IFTHEN=(WHEN=NONE,OVERLAY=(114:SEQNUM,8,ZD,
106:106,8,ZD,SUB,114,8,ZD,M11,LENGTH=8))
The error follows
SYT000I SYNCTOOL RELEASE 1.5A - COPYRIGHT 2004 SYNCSORT INC.
SYT001I INITIAL PROCESSING MODE IS "STOP"
SYT002I "TOOLIN" INTERFACE BEING USED
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
ScottUrban,
From the error messages I see that you are using Syncsort. I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort.
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
There is no need to start a new topic. . .
There is a need for you slow down, pay more attention to what you post/test and to follow suggestions. . . (i.e. Is there some reason you have not yet "Code"ed your jcl/control statements?).
Joined: 23 Apr 2007 Posts: 50 Location: Jefferson City, Mo
Excuse me... you may want to check what you have read... I have coded and executed the suggested code from Kolusu.. I was unaware my new company was not using DFSORT I have only been at this shop for 2 1.5 months. They use Syncsort. So the suggested code using ICETOOL will not work. I was merely asking how to get this thread connected to the syncsort expert to try an accomplish the same thing. If that's a problem then I guess I'm on the wrong website.
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
Quote:
you may want to check what you have read...
Yup, did that - and so should you. . .
Notice that your topic has been changed to include Syncsort in the title seen to the forum and it has been moved from the DFSORT part of the forum to where Syncsort topics are answered.
Quote:
I have coded and executed the suggested code from Kolusu
My comment had nothing to do with the code from "Kolusu" (it is Skolusu - as i suggested, slow down and pay attention), but rather with how you post jcl and "code". Look back over your topic and notice the easy-to-read "Code"ed posts versus the way you continue to post.
Quote:
If that's a problem then I guess I'm on the wrong website.
If you're looking for help or wanting to share something you know, this is a great website. If you bring an attitude, you may not think so
Joined: 23 Apr 2007 Posts: 50 Location: Jefferson City, Mo
I have not brought attitude...I have not had one issue on this website until you decided to cut in to the middle of the communication between Skolusu and myself with what I felt were condesending remarks. If there was an issue with my posts and explaining things clearly, it was addressed when I was asked to provide more information.
You could have a little more tact and a little less ego with your choice of words rather than speaking down to someone as if they were a child with your "slow down and pay attention" remark. I was attempting to post a topic that was hard to explain (for me) as I have not had to deal with it before. If I posted incomplete information and it was not to your liking my apologies.
I posted the JCL as I know how to post the JCL. I tried to do a screen capture but it did not take when I pasted it. It went back to text. I did it the same way I posted the first time and the screen capture worked but it hasn't since.
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
Quote:
you decided to cut in to the middle of the communication between Skolusu and myself with what I felt were condesending remarks
There are several of us who interject when we believe we should. . . If you detected condescending, that would be completely in the "eye of the beholder". I've neither the time nor the motivation to condescend. . .
Quote:
I posted the JCL as I know how to post the JCL.
Which is why i explained how to use the "Code" tag - which you still seem to want to avoid. Do not use "screen capture" for entries here- it typically just makes a mess. Using copy/paste and the "Code" tag will present your info aligned and quite readable.
Another feature you might want to try is the "Preview". If you click Preview, you can see your post as it will appear to the forum, rather than how it appears in the Reply editor.
Support for KEEPBASE was included in SyncSort for z/OS 1.2.1.0 and later.
Based on your post, you are running an older release of the product which does not contain the necessary support.
Honestly, I have not reviewed the entire thread so I cannot answer your question just now. The SYNCTOOL error message was brought to my attention so I logged in to address it. I'm pretty tied up right now, but I will try to get to it soon for you.
ScottUrban,
Please check the below code which will work without KEEPBASE option.The solution has more passes of the data,but the o/p as required can be achived.Most of the control cards are taken/modifed from Kolusu's
suggestion.
Joined: 23 Apr 2007 Posts: 50 Location: Jefferson City, Mo
I am getting a sort statement not found error U0016.. Any help would be great.
Code:
WER415B DSM FACILITY DISABLED
WER164B 1,028K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 0 BYTES RESERVE REQUESTED, 1,000K BYTES USED
WER146B 20K BYTES OF EMERGENCY SPACE ALLOCATED
WER267A SORT STATEMENT : STATEMENT NOT FOUND
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
Joined: 23 Apr 2007 Posts: 50 Location: Jefferson City, Mo
Same error even after I corrected the continuation before column 16
Code:
SYNCSORT FOR Z/OS 1.2.0.1R U.S. PATENTS: 4210961, 5117495 (C) 2005 SYNCSO
*** INFOCROSSING HEALTH CARE *** z/OS 1.6
PRODUCT LICENSED FOR CPU SERIAL NUMBER 2B21E, MODEL 2086 440 LICEN
WER415B DSM FACILITY DISABLED
WER164B 1,028K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 0 BYTES RESERVE REQUESTED, 1,000K BYTES USED
WER146B 20K BYTES OF EMERGENCY SPACE ALLOCATED
WER267A SORT STATEMENT : STATEMENT NOT FOUND
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
Please send me the complete job listing offline and I would be happy to further investigate this issue for you. You can email it as a text attachment to alissa.margulies@syncsort.com.