MVSFORUMS.com

[karimj]

Hello all. I have access to FileAid for IMS. I have tried 2 ways to do the following.
I need to have a count of the amount of a certain value in a field.
ie in a "TYPE CODE" that has Y and N, I need to know the number of Y's and the number of N's.

I have tried to use the FLEX JCL Option and came up with this:

TYPE RUN;
PSB DBNAME=MYCPCSE;
SELECT SEGMENT=MYCSCSRT MAX=ALL
WHERE CS-CAPP-AGCY=4
COUNT SEGMENT=MYCSCSRT
;

Where I am looking for the count of 4's in this field. Running it, I get the count of everything in the field. So this is not working:

So I thought to create a "Selection Criteria" through Option 6: Which created the following for me:

IXPSC MYCPCSE YCNY 06.02.00
DIXPSC ATFD.DEVL.ATFDT8.CNTL FILEAID1
DIXPD1 ATGN.TIMS.DBDLIB MYCPCSE
DIXPD2 NOT USED
DIXPAR NOT USED
DIXPFD ATFD.TIMS.XREFC MYCPCSE
DIXPC1 ATFD.DEVL.COPYLIB
DIXPC2 ATFD.PROD.COPYLIB
1
1
1
3 CS-CAPP-AGCY=4
4MYCSCSRTY S
5
_________________
Karim Jessani