QTP: OUTPUT AT

Kesterson, Roger Roger.Kesterson@mtdsw.com
Tue, 18 Sep 2001 07:18:45 -0700


PH 7.10.G2, OpenVMS 7.1
-----------------------

In the QTP manual, it says that without the START OF option, an OUTPUT AT
action is performed at the end of a transaction group.  I have a QTP program
similar to the following:

ACCESS BOM1

SORT ON PARENT_PART ON COMPONENT_PART ON EFFECTIVE_START_DATE

OUTPUT BOM2 ADD AT COMPONENT_PART
ITEM EFFECTIVE_START_DATE OF BOM2 INITIAL EFFECTIVE_START_DATE OF BOM1

I would have expected the file BOM2 to get the record with the latest
effective start date, but it actually gets the earliest.  The effective
start date is a VMSDATE.  I tried converting it to a CHAR*8 (YYYYMMDD), and
sorting on that, but got the same results.  I didn't get the desired results
until I changed the sort to:

SORT ON PARENT_PART ON COMPONENT_PART ON EFFECTIVE_START_DATE D

This seems to contradict the manual, or is my brain just not functioning
correctly today?

Thanks,

Roger Kesterson
Senior Programming Analyst
MTD Southwest, Inc.