MVSFORUMS.com

webel · Beginner Joined: 01 Dec 2006 Posts: 2 Topics: 1

Hi; I'm trying to combine one file entry row of a fixed value to multiple rows in another file. There is no key to join on. I just want to tack the first file to each entry in the second file. For example:

File 1: 22JAN2007
File 2: aaa bbb ccc
zzz yyy xxx

I'd like the output file to look like:
22JAN2007 aaa bbb ccc
22JAN2007 zzz yyy xxx

I'm not a syncsort expert...I'm sure this can be done, but not quite sure how....

kolusu · Posted: Mon Jan 22, 2007 9:32 am Post subject:

webel,

You can use symbols to pass constant values. Try this job. I assumed that your input files are both 80 bytes Fb recfm. We generate a symbol named "FILE1_VALUE" from file1 and use it later to attach the constant to all records in file2

webel · Beginner Joined: 01 Dec 2006 Posts: 2 Topics: 1

Hi kolusu; Thanks, that worked perfectly! Very Happy

nagarajan.dharani · Beginner Joined: 04 Apr 2007 Posts: 20 Topics: 4

Hi,

I am trying with the below code. If the OPTION STOPAFT=1 is not given
the sort card fails with duplicate symbol definition as this sort card process
only 1 record from the input file. If I have multiple records in the file and is it possible to store the values for the FILE1_VALUE as an array.

Thanks,
Dharani

kolusu · Posted: Fri May 25, 2007 8:29 am Post subject:

nagarajan.dharani · Beginner Joined: 04 Apr 2007 Posts: 20 Topics: 4

Hi kolusu,

Following is my requirement

I have two files file1 and file2. I am sorting the file1 and i have a include cond in this sort. Include cond is field1 in file1 should be present in a set of values
The set of values are from a field of all the records in file2.

Example in file2 there are many records. Following are the filed2 values in file2
field2

1
3
5
7
9

file1 should be sorted out with an include cond (filed1 is equal to (1,3,5,7,9))
Can you pls let me know if this is possible?

Thnx,
Dharani

kolusu · Posted: Fri May 25, 2007 9:21 am Post subject:

nagarajan.dharani,

That's 2 file match and has been covered many times here. Search for "joinkeys" in the utilities forum and you will find many examples

Kolusu
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu

nagarajan.dharani · Beginner Joined: 04 Apr 2007 Posts: 20 Topics: 4

Kolusu,

I am not able to get the exact code. Can you pls help me out?

Thanks,
Dharani

kolusu · Posted: Fri May 25, 2007 10:56 am Post subject:

nagarajan.dharani,

http://www.mvsforums.com/helpboards/viewtopic.php?p=22582#22582

http://www.mvsforums.com/helpboards/viewtopic.php?t=5399
_________________
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu

Phantom · Posted: Fri May 25, 2007 6:11 pm Post subject:

nagarajan.dharani,

Most of the frequently asked questions are already covered in our exclusive FAQ pages. Please check them before posting your queries.

Check here for JCL/SORT FAQs...
http://www.mvsforums.com/helpboards/viewforum.php?f=22

Thanks,
Phantom