|
View previous topic :: View next topic
|
| Author |
Message |
jimsnow
New User
Joined: 20 Feb 2023
Posts: 11
Location: us
|
|
|
|
Hello -
I am attempting to perform a FINDREP within my F1 dataset prior to my JOIN. For example:
F1 = 1X1X1X....
F2 = 121212....
My goal is a FINDREP(IN=C'X',OUT=C'2') on F1 prior to the join. I attempted both an INREC FINDREP before my JNF1CNTL (resulted in no match) and the FINDREP within the control card (resulted in a syntax error):
| Code: |
//JNF1CNTL DD *
INREC BUILD=(1,16,FINDREP=(IN=C'X',OUT=C'2'),C';',
1,16)
|
I am looking for a result to include both the pre and post FINDREP data:
1X1X1X;121212 (followed by the F2 data from the JOIN)
Would appreciate any suggestions! |
|
| Back to top |
|
 |
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2286
Location: USA
|
|
|
|
RTFM:
FINDREP parameter is applied to the whole record only. It cannot be coded inside of BUILD - there must be SORT syntax error message which you try to hide from us!
CHANGE parameter can be applied to a particular field of the record. |
|
| Back to top |
|
|
jimsnow
New User
Joined: 20 Feb 2023
Posts: 11
Location: us
|
|
|
|
| I have, forgive me for missing this in the 3 page manual. Thank you for your help. |
|
| Back to top |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015
Posts: 1442
Location: Bamberg, Germany
|
|
|
|
| You can limit the use of FINDREP with STARTPOS and ENDPOS. That is perhaps what you also intended to do. |
|
| Back to top |
|
|
|
|
