|
View previous topic :: View next topic
|
| Author |
Message |
senjay
Active User
Joined: 10 May 2007
Posts: 147
Location: India
|
|
|
|
Hi,
I have to select some records from a file of LRECL 1000 based on the following condition.
select only the records having blanks from 50th position to 1000th position.
Could you tell me how to do this. |
|
| Back to top |
|
 |
SCANDY
New User
.jpg)
Joined: 08 Aug 2007
Posts: 10
Location: Dalian, China
|
|
|
|
You can use this sort card:
| Code: |
//SYSIN DD *
INCLUDE COND=(50,951,SS,EQ,C' ')
// |
|
|
| Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| I couldn't find the max characters allowed for the total INCLUDE/OMIT statement, but the max for a single Relational Condition Format of character is 256.... Maybe stringing several together might work.... |
|
| Back to top |
|
|
senjay
Active User
Joined: 10 May 2007
Posts: 147
Location: India
|
|
|
|
Hi Scandy,
Code:
//SYSIN DD *
INCLUDE COND=(50,951,SS,EQ,C' ')
//
This won't work for me. Because i need to select records having blanks in all the position between 50 and 1000.
Any more idea? |
|
| Back to top |
|
|
krisprems
Active Member
Joined: 27 Nov 2006
Posts: 649
Location: India
|
|
|
|
senjay
Check this
| Code: |
//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(50,951,CH,EQ,C' ')
//
|
|
|
| Back to top |
|
|
senjay
Active User
Joined: 10 May 2007
Posts: 147
Location: India
|
|
|
|
Thanks.
it's working if i include multiple INCLUDE with 256 as length. |
|
| Back to top |
|
|
|
|
