|
View previous topic :: View next topic
|
| Author |
Message |
Dingu
New User
Joined: 06 Jul 2007
Posts: 10
Location: Chentrappinni
|
|
|
|
In the input file format(CustomerID, Value) given below, there will be a maximum of 3 records for a "CustomerID" with three different "Value".
I need to change the layout as
CustomerID Value1 Value2 Value3
The CustomerID that have only one Record in the input file should have the corresponding "Value" in "Value1" field of the output file and Zeroes in "Value2" and "Value3". How can this be done using SORT(SYNCSORT)
Input Record(FB, 10)
CUSTID1 300
CUSTID1 250
CUSTID1 150
CUSTID2 321
Output(FB, 16)
CUSTID1 300 250 150
CUSTID2 321 0 0 |
|
| Back to top |
|
 |
Bitneuker
CICS Moderator
Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19
|
|
|
|
| Quote: |
How can this be done using SORT(SYNCSORT)
|
Belongs in Franks forum  |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Quote: |
| Belongs in Franks forum |
My Forum is for DFSORT questions. This is a a Syncsort question so it belongs here. |
|
| Back to top |
|
|
Bitneuker
CICS Moderator
Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19
|
|
|
|
 Sorry |
|
| Back to top |
|
|
|
|
