Syntax for merging two different files

srramesh · New User Joined: 11 Jul 2008 Posts: 10 Location: Chennai

Hi tell me syntax for merging two different files?

sysin dd=*
merge fields=(2,3,ch,a)
/*

is it correct?[/img]

Aaru · Posted: Fri Jul 18, 2008 4:15 pm Post subject: Reply to: mergin two files

ramesh,

Alissa Margulies · Posted: Fri Jul 18, 2008 8:30 pm Post subject: Re: mergin two files

srramesh · New User Joined: 11 Jul 2008 Posts: 10 Location: Chennai

[img][/img]

dick scherrer · Posted: Mon Jul 21, 2008 11:47 am Post subject:

Hello,

Better try again. . . Nothing was posted.

It appears you tried to use "img". It is best to use "Code". Please do not try to attach images or screen shots.

When posting, it is a good idea to use Preview so you can see what your post will look like to the forum rather than just what you see in the Reply editor. After Preview, you must click Submit. . .

srramesh · New User Joined: 11 Jul 2008 Posts: 10 Location: Chennai

how to upload my prog...like screenshots...

arcvns · Posted: Tue Jul 22, 2008 11:08 am Post subject:

Ramesh,

Cut Paste your code.
Select the entire code...click the "Code" button...
"Preview" to see everything is fine and then Submit.

Thanks,
Arun

Bharath Nadipally · New User Joined: 24 Jun 2008 Posts: 20 Location: Hyderabad

Alissa Margulies,

Is it possible to merge fields using SORT? If so, can u please give me the logic?

dick scherrer · Posted: Tue Jul 22, 2008 9:21 pm Post subject:

Hello,

Sample MERGE code was posted. Does this not meet your requirement?

If not, you need to post sample input data for 2 files and the output you want from the sample input. Please also menton the recfm and lrecl of the 3 files.

If you are not trying to merge 2 files into a 3rd file, please clarify.

Alissa Margulies · Posted: Wed Jul 23, 2008 2:26 am Post subject:

Bharath Nadipally · New User Joined: 24 Jun 2008 Posts: 20 Location: Hyderabad

Hi,

My requirement is as below.

File1:

field1
field2
field3

File2:

field4
field5
field6

File3(Output file):

field1 field4
field2 field5
field3 field6

dick scherrer · Posted: Wed Jul 23, 2008 9:26 am Post subject:

Hello,

You mention "fields" but what you've posted are records. . .

It will help if you use "real" record and field names and show sample content for those names. Things like account number, amount-due, zip-code, etc.

Keep in mind that a file typically contains records and records contain fields. Every time a file "read" is issued one record is read, not one field.
When posting technical questions it is best to stay with the existing terminology and not introduce new ways of saying things.

Alissa Margulies · Posted: Wed Jul 23, 2008 8:27 pm Post subject:

Bharath,

Is there a common key field between File1 and File2. It does not have to be in the same position for File1 and File2...

Alissa Margulies · Posted: Wed Jul 23, 2008 8:29 pm Post subject:

... Or, do you simply want to pair Record1 from File1 to Record1 of File2, and Record2 from File1 with Record2 of File2, etc...

Frank Yaeger · Posted: Wed Jul 23, 2008 11:10 pm Post subject:

Bharath,

See if the technique described in the "Join fields from two files record-by-record" Smart DFSORT Trick does what you want. You can find it at:

www.ibm.com/systems/support/storage/software/sort/mvs/tricks/