OUTPUT AT

Merol Newman merol.newman@ramesys.com
Tue, 18 Sep 2001 15:51:32 +0100


		
Hello Roger

I'm sure I've puzzled over this one in the past!

Try "final" instead of "initial".

regards
Merol


merol.newman@ramesys.com
Ramesys, Eldon Way, Crick, Northamptonshire, UK. NN6 7SL 
phone 01788 822133/823831, fax 01788 823601 
 

> -----Original Message-----
> From: powerh-l-admin@cube.swau.edu
> [mailto:powerh-l-admin@cube.swau.edu]On Behalf Of Kesterson, Roger
> Sent: 18 September 2001 15:19
> To: 'powerh-l@lists.swau.edu'
> Subject: QTP: OUTPUT AT
> 
> 
> 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.
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l@lists.swau.edu
> Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
> Unsubscribe: "unsubscribe" in message body to powerh-l-request@lists.swau.edu
> http://lists.swau.edu/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
>