Select logical file does not work!

[SuzieW]

Hi all

I have specified a logical file using DDS. The source for the file is:

A          R RPRMPFP                   PFILE(PRMPFP)        
 *                                                          
A          K MPPACKNO                                       
 *                                                          
A          S MPUPLOAD                  COMP(EQ 'Y')         
A          S MPSTATUS                  COMP(EQ 'A')

I would expect that it should only return records with MPUPLOAD field equal to uppercase 'Y', but it also returns those with lowercase y.

(File created in v5r1)

This is an amendment to an existing file which was created in v4r5. The old version of the file works as expected. The change I've made is to add further fields to the physical file and a further selection criteria. I've compared the file descriptions (DSPFD) and can't see anything different in the keywords.

I've looked at the DDS v5r1 manuals to no avail.

Did they change something in v5r1 so that it's case insensitive? This is driving me nuts!

 

[SuzieW]

Found it

In order for the select conditions to be in an "and" relationship, I needed to get rid of the S in the second line. The default is obviously OR.

(Shows how often I use DDS)

Phew!