MVSFORUMS.com

mf_user · Intermediate Joined: 01 Jun 2003 Posts: 372 Topics: 105

Hi,

I wanted to combine two files into a single file. File A and File B content should be present in File B. I am using SYNCSORT. I am getting the same resultant output file (File B) when used the below statements:

dbzTHEdinosauer · Posted: Thu Jul 19, 2007 6:20 am Post subject:

mf_user,

you have been around long enough to know that when you post a question and only provide very little information you will receive very little help. What is you jcl? and job output msgs?

If I understand you correctly, File A and File B are your input files, File B - containing File A is your output. How do you know what you have when you have nothing to compare? destructive updates are not very professional.

When you use the COPY parm of the fields operand of merge, are you not just appending A onto B? Why don't you use an iebgener copying A to B, with B as disp=(mod,keep,keep)?
_________________
Dick Brenholtz
American living in Varel, Germany

blitz2 · Beginner Joined: 23 Jan 2007 Posts: 84 Topics: 14

amargulies · Beginner Joined: 10 Jan 2007 Posts: 123 Topics: 0

mf_user,

Yes, please post the complete JCL that you coded for this job.

Please also note, that for a COPY or MERGE, the output file must not be the same as any of the input files. Therefore, please make sure that although you want the contents of File A and File B in File B, write it out to File C.
_________________
Alissa Margulies
SyncSort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com

krisprems · Posted: Thu Jul 19, 2007 12:42 pm Post subject:

mf_user
If your i/ps are already in sorted order, then use merge to combine them; This increases the efficiency(by using merge).
If the i/ps are not in sorted order, than just use SORT to combine.

regarding this,

mf_user · Intermediate Joined: 01 Jun 2003 Posts: 372 Topics: 105

Hi, dbzTHEdinosauer & others.

Thank you all for the replies and info you have provided.

Here is the JCL:

kolusu · Posted: Mon Jul 23, 2007 6:44 am Post subject:

mf_user,

wow. Your sortin and sortout is the same ? You concatenated the DSN "XXXXX.XXXXX.XXXX.XXXXX.XXXXXXX.XXXXT08" to SORTIN and also it is the same DSN for Sortout? .Also you did not provide us with the sysout messages and how did you expect us to help?

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

mf_user · Intermediate Joined: 01 Jun 2003 Posts: 372 Topics: 105

sysin:

kolusu · Posted: Mon Jul 23, 2007 9:14 am Post subject:

mf_user,

You are just wasting time. You don't even read the questions properly and you only answer partial questions. Go read my prior post and see what I asked.

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

dbzTHEdinosauer · Posted: Mon Jul 23, 2007 9:22 am Post subject:

MF,

as has been said several times, using the same file for input and output does not make much sense, but try changing the disposition on the

input files (SORTIN) to be shr instead of old
output file (SORTOUT) to be old instead of shr.

_________________
Dick Brenholtz
American living in Varel, Germany

mf_user · Intermediate Joined: 01 Jun 2003 Posts: 372 Topics: 105

OK dbzTHEdinosauer. Thanks.
_________________
MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==

dbzTHEdinosauer · Posted: Mon Jul 23, 2007 9:41 am Post subject:

blitz2 · Beginner Joined: 23 Jan 2007 Posts: 84 Topics: 14

reminds me; when I started my career as a fresher, I did not know of any helpboards, did not know the links for IBM manuals, training was hopeless and I was really lost... If it weren't for my mentors in my first project, I would never have been comfortable in the mainframe world.
________
AN1X