<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:D="DAV:" 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:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:st="" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:Z="urn:schemas-microsoft-com:"><head><META content="text/html; charset=utf-8" http-equiv="Content-Type">
<meta content="text/html; charset=utf-8" http-equiv=Content-Type>
<meta content="Microsoft Word 12 (filtered medium)" name=Generator>
<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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","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.apple-style-span
{mso-style-name:apple-style-span;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Tahoma","sans-serif";
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.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>
<DIV>
<div class=Section1>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:blue'>Correct me if I’m wrong but isn’t the answer as simple
as taking the alias off the output command:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:blue'><o:p> </o:p></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'>ACCESS OPTICLEN
&</span></span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> LINK CUN
&</span></span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> TO CUN OF
*$PIC_DATA/OPBEUROD_S
&</span></span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> LINK CRY OF OPBEUROD_S
&</span></span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> TO CURR-CODE OF
IPTIEURO </span></span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'>
</span></span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'>SELECT IF CLAIM-CURR="SKK"</span></span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'>OUTPUT OPTICLEN UPDATE</span></span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> ITEM CLAIM-CURR OF CLEN_UPD
="EUR"</span></span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:blue'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:blue'>This way you will directly update the records that are being read
rather than linking back to the record which is what the alias makes QTP do.
My Powerhouse is getting rusty these days so excuse me if I’ve given dodgy
advice!<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:blue'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:blue'>Regards,</span><span style='color:blue'><br>
</span><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:blue'>Gavin.</span><span style='color:blue'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:blue'><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 lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> Ken Langendock
[mailto:ken.langendock@rogers.com] <br>
<b>Sent:</b> 17 December 2008 15:51<br>
<b>To:</b> 'vamsi krishna'; powerh-l@lists.sowder.com<br>
<b>Cc:</b> 'mRiDuLa'<br>
<b>Subject:</b> RE: [Bulk] Help with QTP UPDATE<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>The problem is you are creating a record complex that may result
in the same record being ready to update more than once.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>What you need to do is get the record complex down to One in and
One out.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Use output phase reading and move your select statement. And
QUALIFY YOUR STATEMENTS<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Ken<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'>ACCESS OPTICLEN</span></span><span class=apple-style-span><span style='font-family:"Courier New"'><o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'><o:p> </o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'>OUTPUT *$PIC_DATA/OPBEUROD_S &<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> ADD
&<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> UPDATE
&<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> NOITEMS
&<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> IF 1 EQ
2 &</span></span><o:p></o:p></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> VIA
CUN &</span></span><span class=apple-style-span><span style='font-family:"Courier New"'><o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> USING CUN OF
OPTICLEN <o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'><o:p> </o:p></span></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'>OUTPUT IPTIEURO &</span></span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> ADD
&</span></span><span class=apple-style-span><span style='font-family:"Courier New"'><o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> UPDATE
&<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> NOITEMS
&<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> IF 1 EQ
2 &</span></span><o:p></o:p></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> VIA
CURR-CODE & </span></span><span class=apple-style-span><span style='font-family:"Courier New"'><o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> USING CRY OF
OPBEUROD_S <o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'>
</span></span><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'>OUTPUT OPTICLEN &</span></span><span class=apple-style-span><span style='font-family:"Courier New"'><o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> ALIAS
CLEN_UPD &<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> UPDATE
&</span></span><o:p></o:p></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> IF
CLAIM-CURR OF IPTIEURO = "SKK"</span></span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'><o:p> </o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> ITEM CLAIM-CURR OF CLEN_UPD
FINAL "EUR"</span></span><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>
powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com] <b>On
Behalf Of </b>vamsi krishna<br>
<b>Sent:</b> December 17, 2008 9:07 AM<br>
<b>To:</b> powerh-l@lists.sowder.com<br>
<b>Cc:</b> mRiDuLa<br>
<b>Subject:</b> [Bulk] Help with QTP UPDATE<o:p></o:p></span></p>
</div>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Hi All,<o:p></o:p></span></p>
<div>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US>I need to update an indexed file which has
no unique key, but all "repeating primary" and "repeating
alternate" indexes.<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US>When i compile the program, I get the
following warning:<o:p></o:p></span></p>
</div>
<div>
<div>
<p class=MsoNormal><span class=apple-style-span><b><span lang=EN-US style='background:yellow'>*W* Linkage should be via a unique key/index if the
file is output only.</span></b></span><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US>Program is something like this:<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
</div>
<div>
<div>
<div>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'>ACCESS OPTICLEN
&</span></span><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> LINK CUN
&</span></span><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> TO CUN OF
*$PIC_DATA/OPBEUROD_S
&</span></span><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> LINK CRY OF OPBEUROD_S
&</span></span><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> TO CURR-CODE OF
IPTIEURO </span></span><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'>
</span></span><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<div>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'>SELECT IF CLAIM-CURR="SKK"</span></span><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
</div>
<div>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'>OUTPUT OPTICLEN ALIAS CLEN_UPD UPDATE</span></span><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<div>
<p class=MsoNormal><span class=apple-style-span><span lang=EN-US style='font-family:"Courier New"'> ITEM CLAIM-CURR OF CLEN_UPD
="EUR"</span></span><span lang=EN-US><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
</div>
</div>
</div>
</div>
</div>
<div>
<p class=MsoNormal><span lang=EN-US>I realize when the QTP runs, the control
breaks are set on the primary index by default, and the output update runs on
next unique value of repeating index.<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US>So, all the needed records in the selection
are not updated.<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US>It would be of great help if I can set a
control break so that every record in selection is updated.<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US>Correct me if I am going anywhere, or any
other perfect way of updating such files.<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US>We have PowerHouse 8.43.D on
Solaris SunOS.<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
</div>
</div>
<div>
<p class=MsoNormal><span lang=EN-US>Thanks in advance.<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US>Regards,<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-US>Vamsi<br clear=all>
<br>
-- <br>
"Nothing is impossible as impossible itself says i m possible"<o:p></o:p></span></p>
</div>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p><span lang=EN-US style='font-size:10.0pt'>No virus found in this incoming
message.<br>
Checked by AVG.<br>
Version: 7.5.552 / Virus Database: 270.9.18/1852 - Release Date: 16/12/2008
6:11 PM</span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p><span style='font-size:10.0pt'>No virus found in this outgoing message.<br>
Checked by AVG.<br>
Version: 7.5.552 / Virus Database: 270.9.18/1852 - Release Date: 16/12/2008
6:11 PM</span><o:p></o:p></p>
</div>
</DIV>
<DIV> </DIV>
<DIV>
<P CLASS="MsoNormal" STYLE="MARGIN: 0in 0in 0pt"><SPAN LANG="EN-GB" STYLE="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"><FONT COLOR="gray">Registered No. 755780 England</FONT></SPAN></P>
<P CLASS="MsoNormal" STYLE="MARGIN: 0in 0in 0pt"><SPAN LANG="EN-GB" STYLE="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"><FONT COLOR="gray">Registered Office: FM Insurance Company Limited</FONT></SPAN></P>
<P CLASS="MsoNormal" STYLE="MARGIN: 0in 0in 0pt"><SPAN LANG="EN-GB" STYLE="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"><FONT COLOR="gray">1 Windsor Dials, Windsor,</FONT></SPAN></P>
<P CLASS="MsoNormal" STYLE="MARGIN: 0in 0in 0pt"><SPAN LANG="EN-GB" STYLE="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"></SPAN><SPAN LANG="EN-GB" STYLE="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"><FONT COLOR="gray">Berkshire, UK, SL4 1RS</FONT></SPAN></P>
<P CLASS="MsoNormal" STYLE="MARGIN: 0in 0in 0pt"><SPAN LANG="EN-GB" STYLE="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"><FONT COLOR="gray">Regulated by the Financial Services Authority.</FONT></SPAN></P>
<P CLASS="MsoNormal" STYLE="MARGIN: 0in 0in 0pt"><SPAN LANG="EN-GB" STYLE="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"><FONT COLOR="gray">VAT No. G.B.: 792 4276 02</FONT></SPAN></P></DIV></BODY></HTML>