View previous topic :: View next topic
|
Author |
Message |
comp_ashok
New User
Joined: 30 Nov 2007 Posts: 15 Location: India
|
|
|
|
input file1: account no- col 2 to 5 pic(4), amount- col 10 to 12 ,pic(3)
12222abcd600xyz
2dfsdjgfsjopgopgg
2sadhgjdfgudgjgid
13333ghij250abc
12222uhki500dxc
14444ghyt900sxz
22222abcd2001on
13333kilo750olk
input file2: account no- col 2 to 5 pic(4), amount- col 6 to 9 ,pic(3)
122221600xyz
2dfsdjgfsjopgopgg
2sadhgjdfgudgjgid
133332250abc
122223500dxc
144449900sxz
22222abcd2001on
133330750olk
input file3: account no- col 2 to 5 pic(4), amount- col 10 to 12 ,pic(3)
16666abcd600xyz
2dfsdjgfsjopgopgg
2sadhgjdfgudgjgid
17777ghij250abc
12222uhki500dxc
14444ghyt900sxz
26666abcd2001on
15555kilo750olk
output file should be?
account no | field of file1 | field of file2 | field of file3
pic 9(10) | pic? | pic ? | pic ?
pic clausa is to identify for ? .
Specifications:
1) select only those records which have 1 in the first byte
2) output file should be ksds with account no as key |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
It's not clear what you want.
Quote: |
input file2: account no- col 2 to 5 pic(4), amount- col 6 to 9 ,pic(3)
|
6-9 is 4 columns but you have pic(3) - is it 7-9?
Quote: |
output file should be?
account no | field of file1 | field of file2 | field of file3
pic 9(10) | pic? | pic ? | pic ?
pic clausa is to identify for ? .
|
I have no idea what this means.
Please show the expected output records for your example input records.
What is the RECFM and LRECL of each input file? |
|
Back to top |
|
|
|