SUM FIELDS=NONE

pjnithin · Active User Joined: 22 Dec 2005 Posts: 116

When we use sum fields=none, which record among the duplicate records will be retained. Is it always the first record that occur among the group of duplicate records that will be retained or it picks some record randomly.

sril.krishy · Posted: Mon May 12, 2008 6:53 pm Post subject:

If you have coded the EQUALS ,then it will pick up the first record.Else it will pick in random order.You can check the default option set for this in your system.

Thanks
Krishy

CICS Guy · Posted: Mon May 12, 2008 6:58 pm Post subject:

Have you checked the sort manual?
When records are summed, you can predict which record is to receive the sum (and be retained) and which record is to be deleted only when EQUALS is in effect, overflow does not occur, and the BLOCKSET technique is used. In this case, the first record (based on the sequence described under the discussion of the EQUALS or NOEQUALS parameter of the "OPTION Control Statement" in topic 3.12) is chosen to contain the sum.
I'd assume that this would apply even with NONE specified.....

Frank Yaeger · Posted: Mon May 12, 2008 9:13 pm Post subject: