[comp.databases] Informix poser

eboneste@bbn.com (Liz Bonesteel) (07/26/90)

I have been trying to debug an ACE report on a zillion-year-old
version of Informix (c. 1983).  The problem is thus: some entries seem
to be being dropped from the final report.  However, if I specify a
missing entry specifically in the READ statement, it shows up.  Code
follows:

    read into x usage equipment labs
          where (eqp_code <> "VALID"
                and eqp_code <> "SYMB"
                and eqp_track = "Y" and eqp_ctl_no = 1039)
         joining eqp_ctl_no = optional usg_ctl_no
         and eqp_lab_no = optional lab_lab_no
    end

    read into y all of x
         where x.usg_acty_per = actyper1 or
    	       x.usg_acty_per = actyper2 or   
    	       x.usg_acty_per = "00" or
    	       x.usg_acty_per = "  "
    end

If I remove "and eqp_ctl_no = 1039", I get no data on 1039.

In the version I use now, if there were truly no data for 1039, the
above code would produce nothing.  Is there something in the way this
dinosaur parses stuff that's different?

Any and all leads will be appreciated.

Thanks,

Liz