<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Arial","sans-serif";
color:navy;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>In this case, yes, this was only
an example of how to code an OUTPUT PHASE READ. But if you are also need to
pull another dozen descriptions it can all be done in one request.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Rather than complicate the code
I kept it simple.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>You all know your systems and
your reports, look at them and see if there is an opportunity<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Ken<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> David Morrison
[mailto:DMorrison@mcbrideinc.com] <br>
<b>Sent:</b> August 18, 2009 4:51 PM<br>
<b>To:</b> Ken@Langendock.com; powerh-l@lists.sowder.com<br>
<b>Subject:</b> [Bulk] RE: Performance Questions and a little need for some
education. - Output Phase reading<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Ken,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Wow, I don’t think I’ve seen that trick before!<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Wouldn’t it be more straightforward (and execute faster?) to
break this snippet into 2 requests:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>REQUEST ONE<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>ACCESS
Orders &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
LINK OrderNumber OF Orders &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
TO OrderNumber &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
OF OrderDetails<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
SORT ON ProductNumber OF OrderDetails &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
ON DateLastOrder OF OrderDetails<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>SUBFILE
subfile1 &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
TEMPORARY &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
INCLUDE whatever<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>SET FILE Orders OPEN READ<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>SET FILE OrderDetails OPEN READ<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>REQUEST TWO<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>ACCESS subfile1 &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> LINK ProductNumber <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> OF Subfile1 <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> TO ProductNumber <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'> OF Products<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>SUBFILE subfile2 KEEP INCLUDE <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>
Subfile1, ProductName<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>SET FILE subfile1 OPEN READ<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>SET FILE Products OPEN READ<o:p></o:p></span></p>
<div>
<p><span style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif";
color:blue'><o:p> </o:p></span></p>
<p><span style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif";
color:blue'>David Morrison</span><span style='color:blue'> <br>
</span><span style='font-size:10.0pt;font-family:"Trebuchet MS","sans-serif";
color:blue'>IT Department<br>
858-450-1414 ext. 4211</span><o:p></o:p></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><span
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>
<hr size=2 width="100%" align=center>
</span></div>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
powerh-l-bounces+dmorrison=mcbrideelectric.com@lists.sowder.com
[mailto:powerh-l-bounces+dmorrison=mcbrideelectric.com@lists.sowder.com] <b>On
Behalf Of </b>Ken Langendock<br>
<b>Sent:</b> Tuesday, August 18, 2009 1:20 PM<br>
<b>To:</b> powerh-l@lists.sowder.com<br>
<b>Subject:</b> RE: Performance Questions and a little need for some education.
- Output Phase reading</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>Yep that is what I meant.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>The advantages:<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>If you relate this to a QUICK
screen; you have a Primary file and some detail/secondary files and reference
files.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>In QTP the only thing you need
to access (via the ACCESS statement are the Primary and/or Secondary/detail
files.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>All other files can be read in
the OUTPUT PHASE (obviously that rule is subjective depending on the desired
record complex).<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>For example:<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>In a screen you could have:<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>FILE Orders PRIMARY<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>FILE OrderDetails DETAIL<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>FILE Products REFERENCE<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Show the order info, detail info
and the product description…etc.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>In QTP you can set the same thing
up like this:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>ACCESS
Orders &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
LINK OrderNumber OF Orders &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
TO OrderNumber &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
IN OrderDetails<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
SORT ON ProductNumber OF OrderDetails &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
ON DateLastOrder OF OrderDetails<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>OUTPUT
Products &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
AT ProductNumber &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
ADD &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
UPDATE &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
NOITEMS &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
IF 1 EQ 2 &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
VIA ProductNumber &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
USING ProductNumber OF OrderDetails<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>SUBFILE
subfile1 &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
KEEP &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
AT ProductNumber &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
INCLUDE whatever<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Ken<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Dan Lambshead [mailto:dlambshe@milk.org]
<br>
<b>Sent:</b> August 18, 2009 3:25 PM<br>
<b>To:</b> Ken@Langendock.com; powerh-l@lists.sowder.com<br>
<b>Subject:</b> [Bulk] RE: Performance Questions and a little need for some
education.<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'>Hi Ken,</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'> 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).</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'>Dan</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
</div>
</body>
</html>