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.
>