MVSFORUMS.com

[ANDY]

Hello,

I have two dataset with the same format and I want to merge them to one(without any condition) using SPLICE of ICETOOL to realize it.

//TOOLIN DD *
SPLICE FROM(IN) TO(OUT8) ON(1,4,CH) WITH(1,100) WITHALL
//
I try the above JCL. Since I just want to merge, how can I omit the condition to let them merge to one dataset?

kolusu,

I have searched message for this topic and not found solution, I am afraid
you will let me to do the search again.
_________________
cheers,
Andy

[kolusu]

Andy,

I cannot provide you a solution without any sample data. Provide us with sample data, LRECL, RECFM & positions and format of the fields to be merged . Mean while check this links which might help you

http://www.mvsforums.com/helpboards/viewtopic.php?t=10&highlight=merge

http://www.mvsforums.com/helpboards/viewtopic.php?t=2820&highlight=merge

http://www.mvsforums.com/helpboards/viewtopic.php?t=2633&highlight=merge

Thanks

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[ANDY]

TRY1 sample data:

EQRX111 2004-07-31SFINTDEFEDSMTP
EQRX124 N199109000919
EQRX126 N199109

TRY2 sample data:

CURRENT 199110
CURRENT 199110 ss
0101BABENTER 9999500
0101BUYUK 9999500
0101UBA 9999500

Expectation TRY3:

CURRENT 199110
CURRENT 199110 ss
0101BABENTER 9999500
0101BUYUK 9999500
0101UBA 9999500
EQRX111 2004-07-31SFINTDEFEDSMTP
EQRX124 N199109000919
EQRX126 N199109


//STEP002 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=ANDY.TEST.TRY1,DISP=(OLD,KEEP)
// DD DSN=ANDY.TEST.TRY2,DISP=(OLD,KEEP)
//OUT DD DSN=ANDY.TEST.TRY3,
// DISP=(,CATLG,DELETE),
// DCB=(LRECL=80,BLKSIZE=0,DSORG=PS,RECFM=FB),UNIT=SYSDA,
// SPACE=(CYL,(50,10),RLSE)
//TOOLIN DD *
SPLICE FROM(IN) TO(OUT) ON(1,4,CH) WITH(1,303) WITHALL
//
_________________
cheers,
Andy

[Cogito-Ergo-Sum]

Uh.. You want merge whereas your example shows simple concatenation. You mean concatenation when you say merge, is it?

Use SORT, where SORTIN is concatenated input of two datasets. In SYSIN, put OPTION COPY.
_________________
ALL opinions are welcome.

Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.

[Frank Yaeger]

Andy,

The SPLICE operator of DFSORT's ICETOOL is for joining fields from different records on a key, or for matching records on a key.

The MERGE statement of DFSORT is for merging records from different files that are each already sorted on a key.

What you appear to want to do is concatenate the records from TRY1 after the records from TRY2. For that, you would use the COPY statement of DFSORT as follows:

[ANDY]

Hello friends,

This is a good forum. Everyone is warm and kind to help others.

Thank you many times.
_________________
cheers,
Andy