OVERLAY Counterpart in SYNCSORT

prabs2006 · Active User Joined: 12 Jan 2006 Posts: 103

Hi

is there any counterpart for OVERLAY(DFSORT command) in SYNCSORT?

prabhu

dick scherrer · Posted: Mon Mar 19, 2007 7:45 pm

Hello,

Please post what data you have as input and what you want the output to be.

When we see what data you have and what output you want, we may be able to offer suggestions.

guptae · Posted: Mon Mar 19, 2007 8:35 pm

Hi Prabhu,

In syncsort u can directly specify what u want to overlay
like to overlay seqnum at the end of record

prabs2006 · Active User Joined: 12 Jan 2006 Posts: 103

EKTA,

Thanks for the reply.

INREC OVERLAY in DFSORT appends records to an existing file. But SYNCSORT doesn't recognize this OVERLAY.

My requirement is to append new records in downwards .

If more clarification required please let me know

Prabhu

guptae · Posted: Tue Mar 20, 2007 11:38 am

Hi Prabhu,

Would u please give i/p & o/p details?

prabs2006 · Active User Joined: 12 Jan 2006 Posts: 103

Hi EKTA,

I have pasted the JCl. Records from file1 is getting overridden by file2.

//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN1 DD DSN=IYMN.TRAN.YMD26109.G1294V00,
// DISP=SHR
//IN2 DD DSN=TEST.GRP.NUMBERS,
// DISP=SHR
//T1 DD DSN=TEST.T5,UNIT=SYSDA,SPACE=(TRK,(5,5)),
// DISP=(NEW,CATLG,DELETE)
//OUT12 DD SYSOUT=*
//OUT1 DD SYSOUT=*
//OUT2 DD SYSOUT=*
//TOOLIN DD *
COPY FROM(IN1) TO(T1) USING(CTL1)
COPY FROM(IN2) TO(T1) USING(CTL2)
SPLICE FROM(T1) TO(OUT12) ON(6,6,CH) WITH(1102,1) -
USING(CTL3) KEEPNODUPS
/*
//CTL1CNTL DD *
INREC OVERLAY=(1101:C'11')
//CTL2CNTL DD *
INREC OVERLAY=(1101:C'22')
//CTL3CNTL DD *
OUTFIL FNAMES=OUT12,INCLUDE=(1101,2,CH,EQ,C'12'),OUTREC=(1:6,6)
OUTFIL FNAMES=OUT1,INCLUDE=(1101,2,CH,EQ,C'11'),OUTREC=(1:1,1100)
OUTFIL FNAMES=OUT2,INCLUDE=(1101,2,CH,EQ,C'22'),OUTREC=(1:1,1100)
/*

dick scherrer · Posted: Tue Mar 20, 2007 7:05 pm

Hello,

You need to post actual input data and what you want the output to look like.