<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: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:D="DAV:" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" 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:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" 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:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" 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=utf-8">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<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;
font-family:"Tahoma","sans-serif";
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle21
{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='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Not if the resulting complex repeats the primary file.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>You will get a “Record has changed since you found it” type
message.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Ken<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
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"'>
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>Lloyd, Gavin<br>
<b>Sent:</b> December 17, 2008 1:10 PM<br>
<b>To:</b> vamsi krishna; powerh-l@lists.sowder.com<br>
<b>Subject:</b> [Bulk] RE: [Bulk] Help with QTP UPDATE<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<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 style='font-family:"Courier New"'>ACCESS
OPTICLEN
&</span></span><o:p></o:p></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
LINK CUN
&</span></span><o:p></o:p></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
TO CUN OF *$PIC_DATA/OPBEUROD_S
&</span></span><o:p></o:p></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
LINK CRY OF OPBEUROD_S
&</span></span><o:p></o:p></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
TO CURR-CODE OF IPTIEURO </span></span><o:p></o:p></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
</span></span><o:p></o:p></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>SELECT
IF CLAIM-CURR="SKK"</span></span><o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>OUTPUT
OPTICLEN UPDATE</span></span><o:p></o:p></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
ITEM CLAIM-CURR OF CLEN_UPD ="EUR"</span></span><o:p></o:p></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 style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
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 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 style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span 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 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 style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Ken<o:p></o:p></span></p>
<p class=MsoNormal><span 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 style='font-family:"Courier New"'>ACCESS
OPTICLEN<o:p></o:p></span></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 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 style='font-family:"Courier New"'>
ADD &<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
UPDATE &<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
NOITEMS &<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span 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 style='font-family:"Courier New"'>
VIA CUN &<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span 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 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 style='font-family:"Courier New"'>OUTPUT
IPTIEURO &</span></span><o:p></o:p></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
ADD &<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
UPDATE &<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
NOITEMS &<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span 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 style='font-family:"Courier New"'>
VIA CURR-CODE & <o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span 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 style='font-family:"Courier New"'>
</span></span><o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>OUTPUT
OPTICLEN &<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
ALIAS CLEN_UPD &<o:p></o:p></span></span></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
UPDATE &</span></span><o:p></o:p></p>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
IF CLAIM-CURR OF IPTIEURO = "SKK"</span></span><o:p></o:p></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 style='font-family:"Courier New"'>
ITEM CLAIM-CURR OF CLEN_UPD FINAL "EUR"</span></span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span 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 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+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><o:p> </o:p></p>
<p class=MsoNormal>Hi All,<o:p></o:p></p>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>I need to update an indexed file which has no unique key,
but all "repeating primary" and "repeating alternate"
indexes.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>When i compile the program, I get the following warning:<o:p></o:p></p>
</div>
<div>
<div>
<p class=MsoNormal><span class=apple-style-span><b><span style='background:
yellow'>*W* Linkage should be via a unique key/index if the file is output
only.</span></b></span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>Program is something like this:<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<div>
<div>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>ACCESS
OPTICLEN
&</span></span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
LINK CUN
&</span></span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
TO CUN OF *$PIC_DATA/OPBEUROD_S
&</span></span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
LINK CRY OF OPBEUROD_S
&</span></span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
TO CURR-CODE OF IPTIEURO </span></span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
</span></span><o:p></o:p></p>
</div>
<div>
<div>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>SELECT
IF CLAIM-CURR="SKK"</span></span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>OUTPUT
OPTICLEN ALIAS CLEN_UPD UPDATE</span></span><o:p></o:p></p>
</div>
<div>
<div>
<p class=MsoNormal><span class=apple-style-span><span style='font-family:"Courier New"'>
ITEM CLAIM-CURR OF CLEN_UPD ="EUR"</span></span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
</div>
</div>
</div>
<div>
<p class=MsoNormal>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></p>
</div>
<div>
<p class=MsoNormal>So, all the needed records in the selection are not updated.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>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></p>
</div>
<div>
<p class=MsoNormal>Correct me if I am going anywhere, or any other perfect way
of updating such files.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>We have PowerHouse 8.43.D on Solaris SunOS.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
<div>
<p class=MsoNormal>Thanks in advance.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>Regards,<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>Vamsi<br clear=all>
<br>
-- <br>
"Nothing is impossible as impossible itself says i m possible"<o:p></o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p><span 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><o:p></o:p></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>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:gray'>Registered No. 755780 England</span><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:gray'>Registered Office: FM Insurance Company Limited</span><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:gray'>1 Windsor Dials, Windsor,</span><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:gray'>Berkshire, UK, SL4 1RS</span><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:gray'>Regulated by the Financial Services Authority.</span><o:p></o:p></p>
<p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:gray'>VAT No. G.B.: 792 4276 02</span><o:p></o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p><span 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><o:p></o:p></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>
</body>
</html>