|
View previous topic :: View next topic
|
| Author |
Message |
meenakshi_forum
Warnings : 1
Active User
Joined: 27 May 2008
Posts: 121
Location: India
|
|
|
|
Hello everyone,
I need a file(say FILE4) whose maximum no. of fields are avaialable in a file(say FILE1) based on record type- 3(record type is a field in FILE1), other fields in the FILE4 are available in FILE1 based on record type-4.
Key field in FILE1 is Account number field.
Please let me know how i can achieve it.
What i feel is that, i can split FILE1 based on record type.
After splitting i will have 2 files say FILE2 and FILE3.
I'll join these 2 files to create FILE4 based on Account number and include the fields which are required from both FILE2 and FILE3.
Please let me know if i am correct, if so please provide me the syntax.
If you have some other approach then do let me know with syntax.
Thanks. |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Post good examples of the input data, what you want for output from that example data and the rules for getting from the input to the output.
Also mention the recfm and lrecl of each file. |
|
| Back to top |
|
|
|
|
