View previous topic :: View next topic
|
Author |
Message |
vissubhai
New User
Joined: 07 Nov 2007 Posts: 12 Location: Hyderabad
|
|
|
|
Coming to my problem, I have two files 1 and 2. And I want to concatenate each record of file 1 with all the records of file 2.
Here's an example to describe the same:
File 1
AB
BC
CD
File 2
11
22
33
44
Expected Output:
AB11
AB22
AB33
AB44
BC11
BC22
BC33
BC44
CD11
CD22
CD33
CD44
Let me know if you need any more clarification on this topic. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
vissubhai,
What is your input/output RECFM/LRECL.?
If you have the latest DFSORT version, I guess you can achieve it through a JOIN application. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Assuming your input files are FB, you can use a DFSORT JOINKEYS job like the following to do what you asked for:
Code: |
//S1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//IN1 DD *
AB
BC
CD
/*
//IN2 DD *
11
22
33
44
/*
//SORTOUT DD SYSOUT=*
//SYSIN DD *
JOINKEYS F1=IN1,FIELDS=(3,1,A),SORTED
JOINKEYS F2=IN2,FIELDS=(3,1,A),SORTED
REFORMAT FIELDS=(F1:1,2,F2:1,2)
OPTION COPY
/*
|
|
|
Back to top |
|
|
vissubhai
New User
Joined: 07 Nov 2007 Posts: 12 Location: Hyderabad
|
|
|
|
Thanks a lot Frank!! The solution worked like a Charm |
|
Back to top |
|
|
|