Date:         Fri, 19 May 1995 15:47:05 -0500
Reply-To:     The NOMAD2 Discussion List
Sender:       The NOMAD2 Discussion List
From:         Mary Lou Arundell 556-9050
Subject:      ZNAV
X-To:         nomad2-l%tamvm1.tamu.edu%external@beta.uc.edu

Friends:

My question regards using ZNAV in LIST.  Here's my database:

          Item1 as A20
          Item2 as 999.99


My goal:  a summary report by item1.  Some of Item2's values are
&nav.

LIST rejects this syntax:

        LIST FROM MYDB BY ITEM1
                 sum(ZNAV(ITEM2))

and rejects this syntax:

        LIST FROM MYDB BY ITEM1
                 ZNAV(SUM(ITEM2))



NOMAD allows this bypass:

        DEFINE FROM MYDB ZITEM AS 999.99 = ZNAV(ITEM2);
        LIST FROM MYDB BY ITEM1
                      SUM(ZITEM)


I conclude that you can't combine ZNAV with SUM.  But what I find
more curious is that the expression ZNAV(ITEM2) while allowed in
the DEFINE, is not allowed by LIST, even without any SUM function
in front of it; ie:

        LIST FROM MYDB BY ITEM1
                       ZNAV(ITEM2)


To list the item with the ZNAV function I have to fake it out
like this:

        LIST FROM MYDB BY ITEM1
                          (0 + ZNAV(ITEM2))


Does this fit with others' experience?  Suggestions?


Thanks for your thoughts.
Mary Lou Arundell               MVS, NOMAD 6.02
Univ of Cincinnati
marylou.arundell@uc.edu


back to index