Performance Questions and a little need for some education. - Output Phase reading

[Ken Langendock]

Yep that is what I meant.

 

The advantages:

If you relate this to a QUICK screen; you have a Primary file and some
detail/secondary files and reference files.

 

In QTP the only thing you need to access (via the ACCESS statement are the
Primary and/or Secondary/detail files.

All other files can be read in the OUTPUT PHASE (obviously that rule is
subjective depending on the desired record complex).

 

For example:

In a screen you could have:

FILE Orders PRIMARY

FILE OrderDetails DETAIL

FILE Products REFERENCE

Show the order info, detail info and the product description.etc.

 

 

In QTP you can set the same thing up like this:

ACCESS Orders &

  LINK OrderNumber OF Orders &

    TO OrderNumber &

    IN OrderDetails

 

  SORT ON ProductNumber OF OrderDetails &

       ON DateLastOrder OF OrderDetails

 

OUTPUT Products &

       AT ProductNumber &

       ADD &

       UPDATE &

       NOITEMS &

       IF 1 EQ 2 &

       VIA   ProductNumber &

       USING ProductNumber OF OrderDetails

    

 

SUBFILE subfile1 &

        KEEP &

        AT ProductNumber &

        INCLUDE whatever

 

 

Ken

 

From: Dan Lambshead [mailto:dlambshe at milk.org] 
Sent: August 18, 2009 3:25 PM
To: Ken at Langendock.com; powerh-l at lists.sowder.com
Subject: [Bulk] RE: Performance Questions and a little need for some
education.

 

Hi Ken,

 

  Just wondering what you mean by "Output Phase Read". Is that when you do
an Output ... if 1 = 2 ... or something like that, so you are only doing a
read? I have seen that before, but now am trying to remember what the
advantages are (if that's what you're talking about).

 

Dan

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20090818/86abfcde/attachment-0001.htm