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: 1222 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: 2455 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: 2010 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: 2455 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 |
|
|
|