MVSFORUMS.com

bobi · Beginner Joined: 15 Jun 2005 Posts: 12 Topics: 7

Hi,
I have a input file in ASCII format i want to filter the records on this condition INCLUDE COND=((1,9,PD,GE,050000000),AND,(1,9,PD,LE,120009999))
but its not working.. but when i give only one codition at a time some files are getting filtered. can any one please tell me how to filter a file with ASCII format.

thanks
bobi

Frank Yaeger · Posted: Thu Jun 23, 2005 11:06 am Post subject:

We need to see what the values in positions 1-9 look like. PD would work for packed decimal values, but not if the values are in some other format.

Run this DFSORT job and post the //SYSOUT output:

bobi · Beginner Joined: 15 Jun 2005 Posts: 12 Topics: 7

hi,
here are the values
484541444552202043
303534303030303030
313131303030303030
313630303030303030
323131303030303030
545241494C45522043

Cant we directly sort a file in ascii format
thanks
bobi

dneufarth · Beginner Joined: 05 Apr 2005 Posts: 11 Topics: 0

Try changing PD to AC (DFSORT).

Dave

dneufarth · Beginner Joined: 05 Apr 2005 Posts: 11 Topics: 0

You may also use CH,GE,x'303530303030303030' and CH,LE,x'313230303039393939'

Dave

kolusu · Posted: Tue Jun 28, 2005 10:09 am Post subject:

Bobi,

I don't think they are packed decimal numbers.A valid Packed decimal field will have the sign in the lowerbit. A 'c' or 'F' for a positive number and 'D' for a negative number.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Frank Yaeger · Posted: Tue Jun 28, 2005 10:52 am Post subject:

Your hex display shows that this is ASCII character data. You can do what you want using an INCLUDE statement like this: