|
View previous topic :: View next topic
|
| Author |
Message |
abhay pratap singh
New User
Joined: 22 Nov 2007
Posts: 77
Location: noida
|
|
|
|
I have file in which contains data as follows:
| Code: |
;Ò Ø @ ïCHALU4.0. 0 ° ¤
005E08070005CCCDEF4F4004F4419390000
00ED000C0047381344B0B010000000F000F
-----------------------------------
;Ó ø¤ M DELHI
005E02010002790000D44444444444CCDCC
00EE010D00800F000F40000000000045389
-----------------------------------
;0 {OFF01OFF02
005F0CDCCFFDCCFF0000444444444444444
00E0006660166602000F000000000000000
-----------------------------------
;7 rrr¤ ° ¤TEST RMK1
005F010100000099991939ECEE4DDDF4444
00E70D09000001999F000F3523094210000 |
I used INCLUDE statement for getting only the record which has data '5EED' in 3rd and 4th position. Below is the INCLUDE statement I used
| Code: |
SORT FIELDS=COPY
INCLUDE COND=(3,2,PD,EQ,5EED)
|
but this is giving error
SYSIN :
| Code: |
SORT FIELDS=COPY
INCLUDE COND=(3,2,PD,EQ,5EED)
*
WER251A INCLUDE/OMIT INVALID LOGICAL OPERATOR
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000 |
Please let me know if I am doing something wrong. |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| Quote: |
| Please let me know if I am doing something wrong. |
You are doing something wrong.
Please read the manual for the correct syntax for the INCLUDE statement. |
|
| Back to top |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007
Posts: 295
Location: Singapore
|
|
|
|
Abhay,
As per the data 3,2 doesn't look like a PD field. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Why do you believe 5EED is packed-decimal? It might be a binary number, but it is definitely not packed-decimal.
What does that value represent? |
|
| Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table
|
|
|
|
How about
| Code: |
SORT FIELDS=COPY
INCLUDE COND=(3,2,CH,EQ,X'5EED') |
or
| Code: |
SORT FIELDS=COPY
INCLUDE COND=(3,2,BI,EQ,24301) |
|
|
| Back to top |
|
|
abhay pratap singh
New User
Joined: 22 Nov 2007
Posts: 77
Location: noida
|
|
|
|
| CICS Guy wrote: |
How about
| Code: |
SORT FIELDS=COPY
INCLUDE COND=(3,2,CH,EQ,X'5EED') |
or
| Code: |
SORT FIELDS=COPY
INCLUDE COND=(3,2,BI,EQ,24301) |
|
I tried both options but getting empty file. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
if the record format is Variable
did You remember to add to the offset/position the 4 bytes of the RDW ??? |
|
| Back to top |
|
|
|
|
