How to check negative and positive values in a flat file

Select-mf · New User Joined: 11 May 2007 Posts: 42 Location: bangalore

The requirement is i have to count all the negative and positive values found for a particular field in a flat file.

The problem is this, the particular field is defined in my file as a packed decimal field, then how can i search for the -ve or +ve values in that.

Is there any method where i can put all the negative values in a separate file and all the positive values in a different file using DFSORT/SORT.

William Thompson · Posted: Sat May 19, 2007 12:32 am

You can have multiple OUTFIL records each with a different output and a different INCLUDE/OMIT condition.....

dick scherrer · Posted: Sat May 19, 2007 3:13 am

Hello,

Please describe the output you want from this when it is working.

Select-mf · New User Joined: 11 May 2007 Posts: 42 Location: bangalore

Can you write its proper syntax, so that i can check in my system.

William Thompson · Posted: Sat May 19, 2007 12:24 pm

Do you need a pointer to a Sort Manual?

Select-mf · New User Joined: 11 May 2007 Posts: 42 Location: bangalore

Hi,

I have tried the SYNCSORT and its working. I have divided the output in four files. In the file the two fields are starting from 100 and 107 respectively.

In SYSIN card, i have coded like

OUTFIL FILES=1,
INCLUDE=(100,7,PD,LT,0,AND,107,7,PD,LT,0)
OUTFIL FILES=2,
INCLUDE=(100,7,PD,GT,0,AND,107,7,PD,GT,0)
OUTFIL FILES=3,
INCLUDE=(100,7,PD,LT,0,AND,107,7,PD,GT,0)
OUTFIL FILES=4,
INCLUDE=(100,7,PD,GT,0,AND,107,7,PD,LT,0)