|
View previous topic :: View next topic
|
| Author |
Message |
Kijo
New User
Joined: 22 Mar 2007
Posts: 9
Location: Philippines
|
|
|
|
i have 2 flat files... the first contains columns a, b and c with 3 records, the other columns x and y with 5 records.
if the value of column x is equal to that of column a my output should be columns a, b, c and y with the same number of records as file 1...
file 1:
a123 b123 c123
a456 b456 c456
a789 b789 c789
file 2:
x123 y000
x222 y111
x456 y000
x789 y000
x888 y111
output:
a123 b123 c123 y000
a456 b456 c456 y000
a789 b789 c789 y000
any suggestions?
thank you very much! |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
What should happen if there are duplicate "keys" in either of the files? |
|
| Back to top |
|
|
Kijo
New User
Joined: 22 Mar 2007
Posts: 9
Location: Philippines
|
|
|
|
Hi,
there's no need to worry about dupes it will be taken care of by a previous job. |
|
| Back to top |
|
|
shankar.v
Active User
Joined: 25 Jun 2007
Posts: 196
Location: Bangalore
|
|
|
|
| Code: |
// EXEC PGM=ICETOOL
//DFSMSG DD SYSOUT=*
//TOOLMSG DD SYSOUT=*
//FILE1 DD *
123 123 123
456 456 456
789 789 789
/*
//FILE2 DD *
123 000
222 111
456 000
789 000
888 111
/*
//T DD DSN=&&T,DISP=(MOD,PASS)
//OUT DD SYSOUT=*
//TOOLIN DD *
COPY FROM(FILE1) TO(T)
COPY FROM(FILE2) TO(T) USING(CTL1)
SPLICE FROM(T) TO(OUT) ON(1,3,CH) WITH(13,3)
/*
//CTL1CNTL DD *
INREC OVERLAY=(13:5,3)
/*
// |
Output:
| Code: |
123 123 123 000
456 456 456 000
789 789 789 000 |
|
|
| Back to top |
|
|
Kijo
New User
Joined: 22 Mar 2007
Posts: 9
Location: Philippines
|
|
|
|
| thank you very much but is it also possible to do this with syncsort? |
|
| Back to top |
|
|
shankar.v
Active User
Joined: 25 Jun 2007
Posts: 196
Location: Bangalore
|
|
|
|
Kijo,
| Quote: |
| but is it also possible to do this with syncsort? |
yes, it is possible in syncsort also. |
|
| Back to top |
|
|
|
|
