Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SYNCSORT Combine three different datasets into one

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

New User


Joined: 02 Feb 2007
Posts: 10
Location: chennai

PostPosted: Mon Oct 29, 2007 4:15 pm    Post subject: SYNCSORT Combine three different datasets into one
Reply with quote

I have three different input datasets. From the first one I have to remove first nine records, from second one I want to remove first 5 records and copy all the remaining records of first and second datasets along with all the records of third datasets into an output dataset.

Mustafa
Back to top
View user's profile Send private message

krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Mon Oct 29, 2007 4:33 pm    Post subject:
Reply with quote

mustafaamani
Code:
//*******************************************************
//STEP001  EXEC PGM=ICETOOL                             
//TOOLMSG  DD SYSOUT=*                                   
//DFSMSG   DD SYSOUT=*                                   
//IN1      DD I/P FILE-1                                 
//IN2      DD I/P FILE-2                                 
//         DD I/P FILE-3                                 
//OUT      DD O/P FILE,DISP=MOD                         
//TOOLIN   DD *                                         
 COPY FROM(IN1)  TO(OUT) USING(CP01)                     
 COPY FROM(IN2)  TO(OUT) USING(CP02)                     
/*                                                       
//CP01CNTL DD   *                                       
  SKIPREC=9                                             
/*                                                       
//CP02CNTL DD   *                                       
  SKIPREC=5                                             
/*                                                       
Back to top
View user's profile Send private message
mustafaamani

New User


Joined: 02 Feb 2007
Posts: 10
Location: chennai

PostPosted: Mon Oct 29, 2007 6:15 pm    Post subject: Reply to: Combine three different datasets into one
Reply with quote

Hi krisprems,
Thanks for ur help. Now i am getting following error

SYT000I SYNCTOOL RELEASE 1.5.3 - COPYRIGHT 2004 SYNCSORT INC.
SYT001I INITIAL PROCESSING MODE IS "STOP"
SYT002I "TOOLIN" INTERFACE BEING USED

SYT006E NO "TOOLIN" DD STATEMENT FOUND

SYT004I SYNCTOOL PROCESSING COMPLETED WITH RETURN CODE 12

Can you please help on this?
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Mon Oct 29, 2007 6:23 pm    Post subject:
Reply with quote

mustafaamani,

What KrisPrems suggested use ICETOOL (DFSORT product). But your shop has SYNCSORT installed.

If I remeber correctly, Use STARTREC in place of SKIPREC.
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Mon Oct 29, 2007 7:41 pm    Post subject:
Reply with quote

mustafaamani
Quote:
SYT006E NO "TOOLIN" DD STATEMENT FOUND


Check whether you have specified the TOOLIN statement as i have done in my ICETOOL JOB.
Else provied the ICETOOL/SYNCTOOL JOB that you have submitted, to help you further.

Or else if you are not comfortable using ICETOOL/SYNCTOOL, just use this SORT JOB
Code:
//*******************************************************               
//STEP1    EXEC PGM=SORT                                               
//SYSOUT   DD SYSOUT=*                                                 
//SORTIN   DD DSN=I/P FILE-1                                           
//SORTOUT  DD DSN=O/P-FILE,DISP=MOD                                     
//SYSIN    DD *                                                         
           SORT FIELDS=COPY,SKIPREC=9                                                   
/*                                                                     
//*******************************************************               
//STEP2    EXEC PGM=SORT                                               
//SYSOUT   DD SYSOUT=*                                                 
//SORTIN   DD DSN=I/P FILE-2                                           
//         DD DSN=I/P FILE-3                                           
//SORTOUT  DD DSN=O/P-FILE,DISP=MOD                                     
//SYSIN    DD *                                                         
           SORT  FIELDS=COPY,SKIPREC=5                                                   
/*                                                                     
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Mon Oct 29, 2007 7:51 pm    Post subject:
Reply with quote

Murli.
Quote:
If I remeber correctly, Use STARTREC in place of SKIPREC.

Have you tried this?

STARTREC and ENDREC are compiant with OUTFIL. So if you want to use STARTREC and ENDREC
my control card would be
Code:
//CP01CNTL DD   *   
  OUTFIL STARTREC=9
/*                   
Back to top
View user's profile Send private message
mustafaamani

New User


Joined: 02 Feb 2007
Posts: 10
Location: chennai

PostPosted: Mon Oct 29, 2007 10:25 pm    Post subject: Reply to: SYNCSORT Combine three different datasets into one
Reply with quote

Hi Murli & KrisPrems,

Thanks very much for your help. But unfortunately this was not working out for me. So i have written one quickjob program instead to perform the required functioanlity in one step. Since this was only one time activity.

Thanks once again,
Mustafa
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 Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts REXX to get the all datasets name parasmalik20 CLIST & REXX 5 Tue Jul 18, 2017 9:10 pm
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm
No new posts Edit large number of datasets (QSAM) zh_lad TSO/ISPF 3 Tue Apr 04, 2017 6:08 pm
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us