|
View previous topic :: View next topic
|
| Author |
Message |
srinivasulu.p
New User
Joined: 10 Jul 2012
Posts: 22
Location: india
|
|
|
|
This is file data, I need to comapre SAA records with other records in CA state IF it matches write in to file pls help me how to acheive using SORT IN JCL
| Code: |
ENTR-D WH-TYPE CUSP-NBR KEY-C BKPG-AMT ST-C
11/02/13 SAA 1233 10 100 CA
11/03/13 WHD 1234 11 400
11/03/13 WHD 1235 12 200
11/04/13 WHD 1236 13 900
11/05/13 WHD 1237 14 10
11/02/13 WHD 1233 10 100
11/02/13 SAA 1233 10 100 NJ
11/03/13 WHD 1234 11 400
11/03/13 WHD 1235 12 200
11/04/13 WHD 1236 13 900
11/05/13 WHD 1237 14 10
11/02/13 WHD 1233 10 100
|
|
|
| Back to top |
|
 |
Akatsukami
Global Moderator
Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL
|
|
|
|
| JOINKEYS. |
|
| Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK
|
|
|
|
| One assumes that you are using Syncsort. What are your dataset attributes (LRECL,RECFM). How about showing sample input and sample output? |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Duplicate topic - locked . . .
d |
|
| Back to top |
|
|
|
|
