|
View previous topic :: View next topic
|
| Author |
Message |
Shubhendu Chakraborty
New User
Joined: 20 Nov 2019
Posts: 3
Location: US
|
|
|
|
Hi,
I have 1 file of 10 bytes, first byte is Key and rest 9 have some value
Ex.
A111111111
B222222222
C333333333
My second file is of 20 bytes, first byte as Key and rest is random value
Ex.
AQWQW111111111ASWQQQ
B222222222QWQEFDFDFRER
CSDFGDFDG333333333FGGG
CFDSFDSFFDSFFSDDSFDSSF
BDFSFDSFFSDFEWREWREEW
My expected result to include records from file 2 which has matching value from file 1 position 2 to 9 bytes with sub string of file 2:
AQWQW111111111ASWQQQ
B222222222QWQEFDFDFRER
CSDFGDFDG333333333FGGG
I tried below but its not working:
JOINKEYS FILES=F1,FIELDS=(1,1,A)
JOINKEYS FILES=F2,FIELDS=(1,1,A)
REFORMAT FIELDS=(F1:1,10,F2:1,20)
SORT FIELDS=(1,10,CH,A)
INCLUDE COND=(12,19,SS,EQ,2,9,CH)
OUTREC=(1:11,20)
Please guide me with the same. |
|
| Back to top |
|
 |
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015
Posts: 1436
Location: Bamberg, Germany
|
|
|
|
Couldn't you decide which SORT product you are using or why do you post the same question for DFSORT and SYNCSORT?  |
|
| Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK
|
|
|
|
| How is it not working? JCL error, program error, wrong data returned, something else? |
|
| Back to top |
|
|
Shubhendu Chakraborty
New User
Joined: 20 Nov 2019
Posts: 3
Location: US
|
|
|
|
It's giving me error at:
INCLUDE COND=(12,19,SS,EQ,2,9,CH)
*
INCLUDE/OMIT FORMATS INCOMPATIBLE |
|
| Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2276
Location: USA
|
|
|
|
| Shubhendu Chakraborty wrote: |
It's giving me error at:
INCLUDE COND=(12,19,SS,EQ,2,9,CH)
*
INCLUDE/OMIT FORMATS INCOMPATIBLE |
1) Do you speak English?
2) If yes, RTFM please. (And then copy here: what exactly have you read?) |
|
| Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK
|
|
|
|
| Please post your code using the code tags. As you posted it is saying INCLUDE is in error whereas I can see that it is the 2 after the EQ that is in error. |
|
| Back to top |
|
|
|
|
  |
All times are GMT + 6 Hours |
|
