Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Error message in SYNCTOOL DATASORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
ballaswaroop

New User


Joined: 20 Sep 2005
Posts: 24

PostPosted: Tue Jun 09, 2009 4:44 pm    Post subject: Error message in SYNCTOOL DATASORT
Reply with quote

Hi,

I am using the following JCL to sort the fields in a file that has a Header as the first record. But when i try to execute the JCL I am getting the following error message.
Code:

//S030     EXEC  PGM=SYNCTOOL                             
//INDD01   DD  DSN=BILLN1.TESTP.S020.ANOUTNO.DATA,DISP=SHR
//OUTDD01  DD  DSN=BILLN1.TESTP.S030.ANOUTNO.SORTOUT,   
//             DISP=(MOD,CATLG,DELETE),                 
//             SPACE=(CYL,(10,5),RLSE)
//LISTOUT  DD  SYSOUT=*                                 
//TOOLMSG  DD  SYSOUT=*                                 
//DFSMSG   DD  SYSOUT=*                                 
//SYSOUT   DD  SYSOUT=*                                 
//TOOLIN   DD  *                                           
      DATASORT FROM(INDD01)  TO(OUTDD01)  HEADER USING(CTL1)
/*                                                         
//CTL1CNTL DD *                                             
      SORT FIELDS=(1,18,CH,A,20,4,CH,A,25,8,CH,D)           
/*               


The error message that I am getting is
SYT000I SYNCTOOL RELEASE 1.5.3 - COPYRIGHT 2004 SYNCSORT INC.
SYT001I INITIAL PROCESSING MODE IS "STOP"
SYT002I "TOOLIN" INTERFACE BEING USED

DATASORT FROM(INDD01) TO(OUTDD01) HEADER USING(CTL1)
SYT048E STATEMENT DOES NOT BEGIN WITH A VALID OPERATOR
SYT030I OPERATION COMPLETED WITH RETURN CODE 12

SYT015I PROCESSING MODE CHANGED FROM "STOP" TO "SCAN" DUE TO OPERATION FAILURE

SYT004I SYNCTOOL PROCESSING COMPLETED WITH RETURN CODE 12

Input file
XYD;ABC;CDE;DATE;CURDE;SYPE;AFEE;NCODE;
000000000000000001;0701;20051201;20191231;USD ;DR ;000000;N;
000000000000000001;1632;20071201;20081130;USD ;CR ;000000;N;
000000000000000001;1692;20061101;20071031;USD ;DR ;000000;N;
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Tue Jun 09, 2009 4:46 pm    Post subject: Reply to: ICETOOL DATASORT
Reply with quote

topic move to the JCL forum because
SYT... messages belong to SYNCSORT

DFSORT/ICETOOL messagse start with ICE...
Back to top
View user's profile Send private message
ballaswaroop

New User


Joined: 20 Sep 2005
Posts: 24

PostPosted: Tue Jun 09, 2009 6:09 pm    Post subject:
Reply with quote

Sorry the program is ICETOOL and NOT PGM=SYNCTOOL
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Jun 09, 2009 6:14 pm    Post subject:
Reply with quote

Quote:
The error message that I am getting is
SYT000I SYNCTOOL RELEASE 1.5.3 - COPYRIGHT 2004 SYNCSORT INC.


Quote:
Sorry the program is ICETOOL and NOT PGM=SYNCTOOL

Talk to somebody at your shop who understands something about reading and comprehension.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Tue Jun 09, 2009 6:17 pm    Post subject: Reply to: SYNCTOOL DATASORT
Reply with quote

it does not make any difference,
You are still using SYNCSORT family products

to ease conversion from IBM sort, ( not have people change JCL' s )
quite often competitive products define aliases so that

ICETOOL points to SYNCTOOL
ICEMAN points to SYNCSORT

so the name does not really give any hint on the product You are using icon_biggrin.gif
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Tue Jun 09, 2009 8:17 pm    Post subject: Re: SYNCTOOL DATASORT
Reply with quote

ballaswaroop wrote:
The error message that I am getting is
SYT000I SYNCTOOL RELEASE 1.5.3 - COPYRIGHT 2004 SYNCSORT INC.
SYT001I INITIAL PROCESSING MODE IS "STOP"
SYT002I "TOOLIN" INTERFACE BEING USED
DATASORT FROM(INDD01) TO(OUTDD01) HEADER USING(CTL1)
SYT048E STATEMENT DOES NOT BEGIN WITH A VALID OPERATOR

Support for DATASORT was included in SYNCTOOL Release 1.6.2 which was incorporated into SyncSort for z/OS 1.3.2. The reason you are encountering the error is because you are running an earlier release of the product which does not support this feature.
Back to top
View user's profile Send private message
ballaswaroop

New User


Joined: 20 Sep 2005
Posts: 24

PostPosted: Tue Jun 09, 2009 8:38 pm    Post subject:
Reply with quote

If SYNCTOOL RELEASE 1.5.3 does not support DATASORT is there any possibility to include a header record using ICETOOL ? I would generate a file with out the header; using ICETOOL sort the file after the sorting would like to insert a header record in the sorted file. I have tried using
//CTL3CNTL DD *
OPTION COPY
OUTFIL FNAMES=OUTDD03
HEADER2=('ANO;','SCODE;EDATE;EXDATE;CCODE;', 'STYPE;AFEE;NCODE;') But the ICETOOL is not able to recognize HEADER2.
Please adivce how to insert header record. I would not like to used DISPLAY command.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Tue Jun 09, 2009 9:01 pm    Post subject:
Reply with quote

Please show me some sample input records and your desired output. Be sure to specify the RECFM and LRECL of your input data set as well.
Back to top
View user's profile Send private message
ballaswaroop

New User


Joined: 20 Sep 2005
Posts: 24

PostPosted: Tue Jun 09, 2009 9:05 pm    Post subject:
Reply with quote

Input Record will be

000000000000000001;0701;20051201;20191231;USD ;DR ;000000;N;
000000000000000001;1632;20071201;20081130;USD ;CR ;000000;N;
000000000000000001;1692;20061101;20071031;USD ;DR ;000000;N;

RECFM=FB,LRECL=80

Output Record should be
XYD;ABC;CDE;DATE;CURDE;SYPE;AFEE;NCODE;
000000000000000001;0701;20051201;20191231;USD ;DR ;000000;N;
000000000000000001;1632;20071201;20081130;USD ;CR ;000000;N;
000000000000000001;1692;20061101;20071031;USD ;DR ;000000;N;
RECFM=FB,LRECL=80

All I need is a ';' delimed file with so that I can download in excel.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Tue Jun 09, 2009 10:00 pm    Post subject:
Reply with quote

So if I understand your example, you are simply copying the input file and adding a header record? If this is correct, then you can code the following:
Code:

//STEP1 EXEC PGM=SORT
//SYSOUT  DD SYSOUT=*
//SORTIN  DD DSN=input.file
//SORTOUT DD DSN=output.file
//SYSIN   DD *                                                   
   SORT FIELDS=COPY                                             
   OUTFIL HEADER2=(1:C'XYD;ABC;CDE;DATE;CURDE;SYPE;AFEE;NCODE;'),
   OUTREC=(1,80),REMOVECC                                       
/*                                                               
Back to top
View user's profile Send private message
ballaswaroop

New User


Joined: 20 Sep 2005
Posts: 24

PostPosted: Wed Jun 10, 2009 3:26 pm    Post subject:
Reply with quote

Thanks Alissa, I know there are various work around to get this done. But would like the header to be inserted using ICETOOL. Please suggest if it is possible.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Jun 10, 2009 3:29 pm    Post subject:
Reply with quote

ballaswaroop wrote:
Thanks Alissa, I know there are various work around to get this done. But would like the header to be inserted using ICETOOL. Please suggest if it is possible.

Any particular reason for this request ?
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Jun 10, 2009 4:14 pm    Post subject:
Reply with quote

I'm kind of icon_eek.gif , seems the only request of this kind on this board-- s/he wants a solution with XXXXTOOL instead of XXXMAN (SORT).
Back to top
View user's profile Send private message
ballaswaroop

New User


Joined: 20 Sep 2005
Posts: 24

PostPosted: Wed Jun 10, 2009 4:14 pm    Post subject:
Reply with quote

Yes.. I have three input files which need to be sorted using various sort cards. And all the O/P files should have the header's after sorting. Using ICETOOL I am able to sort the 3 files but not able insert the header records if there was a way to achive it then I will not be required to code other sort step's. Please advice.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2158
Location: @my desk

PostPosted: Wed Jun 10, 2009 6:29 pm    Post subject:
Reply with quote

ballaswaroop,

Why dont you try including the code provided by Alissa in the XXXXCNTL cards of your SYNCTOOL job?
Back to top
View user's profile Send private message
ballaswaroop

New User


Joined: 20 Sep 2005
Posts: 24

PostPosted: Wed Jun 10, 2009 6:39 pm    Post subject:
Reply with quote

Thanks a lot to everybod; it did work. Special thanks to Alissa.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2158
Location: @my desk

PostPosted: Wed Jun 10, 2009 9:40 pm    Post subject:
Reply with quote

ballaswaroop,

Glad that it's working. Thanks for letting us know.
icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts Error during restore rename archanamuthukrishnan All Other Mainframe Topics 2 Fri Oct 14, 2016 3:30 pm
No new posts Error IEC161I 052(009,XXXRS00)-084 wh... amitc23 JCL & VSAM 10 Wed Oct 12, 2016 5:00 pm
No new posts IDMS/DC-COBOL program - SNAP error wh... rakeshsekar1987 IDMS/ADSO 5 Tue Sep 13, 2016 8:28 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us