<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:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1250">
<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-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@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'>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>
</div>
</body>
</html>
<BR>
<P><FONT SIZE=2>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<BR>
</FONT> </P>