<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
Hi Vamsi<BR clear=all><BR>
<BR>
Is there a unique combination of index and other item values?<BR>
<BR>
If so you can specify an access path with a select on it!<BR>
<BR>
e.g.<BR>
<BR>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'">OUTPUT OPTICLEN &</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> ALIAS CLEN_UPD &</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> UPDATE &</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> VIA <key item> USING <key Value> &</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> IF CLAIM-CURR OF IPTIEURO = "SKK"</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"></SPAN></SPAN> </P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'">SELECT CLEN_UPD IF <other item> = <other item value></SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> </SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> ITEM CLAIM-CURR OF CLEN_UPD FINAL "EUR"</SPAN></SPAN></P>
<SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"></SPAN></SPAN> <BR>
<SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'">Regards,</SPAN></SPAN><BR>
<SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'">Peter Bateman </SPAN></SPAN><BR>
<P class=EC_MsoNormal><BR></P>
<HR id=stopSpelling>
<BR>
From: ken.langendock@rogers.com<BR>To: vamsi.coe@gmail.com; powerh-l@lists.sowder.com<BR>Subject: RE: [Bulk] Help with QTP UPDATE<BR>Date: Wed, 17 Dec 2008 10:50:48 -0500<BR>CC: mridulap2003@gmail.com<BR><BR><BR>
<STYLE>
.ExternalClass p.EC_MsoNormal, .ExternalClass li.EC_MsoNormal, .ExternalClass div.EC_MsoNormal
{margin-bottom:.0001pt;font-size:12.0pt;font-family:'Times New Roman','serif';}
.ExternalClass a:link, .ExternalClass span.EC_MsoHyperlink
{color:blue;text-decoration:underline;}
.ExternalClass a:visited, .ExternalClass span.EC_MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
.ExternalClass p
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:'Times New Roman','serif';}
.ExternalClass span.EC_apple-style-span
{;}
.ExternalClass span.EC_EmailStyle19
{font-family:'Calibri','sans-serif';color:#1F497D;}
.ExternalClass .EC_MsoChpDefault
{;}
@page Section1
{size:612.0pt 792.0pt;}
.ExternalClass div.EC_Section1
{page:Section1;}
</STYLE>
<DIV class=EC_Section1>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">The problem is you are creating a record complex that may result in the same record being ready to update more than once.</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">What you need to do is get the record complex down to One in and One out.</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Use output phase reading and move your select statement. And QUALIFY YOUR STATEMENTS</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Ken</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"> </SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'">ACCESS OPTICLEN</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> </SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'">OUTPUT *$PIC_DATA/OPBEUROD_S &</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> ADD &</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> UPDATE &</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> NOITEMS &</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> IF 1 EQ 2 &</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> VIA CUN &</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> USING CUN OF OPTICLEN </SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> </SPAN></SPAN></P>
<P class=EC_MsoNormal> </P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'">OUTPUT IPTIEURO &</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> ADD &</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> UPDATE &</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> NOITEMS &</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> IF 1 EQ 2 &</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> VIA CURR-CODE & </SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> USING CRY OF OPBEUROD_S </SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> </SPAN></SPAN></P>
<P class=EC_MsoNormal> </P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'">OUTPUT OPTICLEN &</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> ALIAS CLEN_UPD &</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> UPDATE &</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> IF CLAIM-CURR OF IPTIEURO = "SKK"</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> </SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> ITEM CLAIM-CURR OF CLEN_UPD FINAL "EUR"</SPAN></SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"> </SPAN></P>
<DIV style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=EC_MsoNormal><B><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN style="FONT-SIZE: 10pt; 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</SPAN></P></DIV>
<P class=EC_MsoNormal> </P>
<P class=EC_MsoNormal>Hi All,</P>
<DIV>
<P class=EC_MsoNormal> </P></DIV>
<DIV>
<P class=EC_MsoNormal>I need to update an indexed file which has no unique key, but all "repeating primary" and "repeating alternate" indexes.</P></DIV>
<DIV>
<P class=EC_MsoNormal> </P></DIV>
<DIV>
<P class=EC_MsoNormal> </P></DIV>
<DIV>
<P class=EC_MsoNormal>When i compile the program, I get the following warning:</P></DIV>
<DIV>
<DIV>
<P class=EC_MsoNormal><SPAN class=EC_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></P></DIV>
<DIV>
<P class=EC_MsoNormal> </P></DIV>
<DIV>
<P class=EC_MsoNormal>Program is something like this:</P></DIV>
<DIV>
<P class=EC_MsoNormal> </P></DIV>
<DIV>
<DIV>
<DIV>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'">ACCESS OPTICLEN &</SPAN></SPAN></P></DIV>
<DIV>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> LINK CUN &</SPAN></SPAN></P></DIV>
<DIV>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> TO CUN OF *$PIC_DATA/OPBEUROD_S &</SPAN></SPAN></P></DIV>
<DIV>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> LINK CRY OF OPBEUROD_S &</SPAN></SPAN></P></DIV>
<DIV>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> TO CURR-CODE OF IPTIEURO </SPAN></SPAN></P></DIV>
<DIV>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> </SPAN></SPAN></P></DIV>
<DIV>
<DIV>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'">SELECT IF CLAIM-CURR="SKK"</SPAN></SPAN></P></DIV>
<DIV>
<P class=EC_MsoNormal> </P></DIV>
<DIV>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'">OUTPUT OPTICLEN ALIAS CLEN_UPD UPDATE</SPAN></SPAN></P></DIV>
<DIV>
<DIV>
<P class=EC_MsoNormal><SPAN class=EC_apple-style-span><SPAN style="FONT-FAMILY: 'Courier New'"> ITEM CLAIM-CURR OF CLEN_UPD ="EUR"</SPAN></SPAN></P></DIV>
<DIV>
<P class=EC_MsoNormal> </P></DIV></DIV></DIV></DIV></DIV>
<DIV>
<P class=EC_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.</P></DIV>
<DIV>
<P class=EC_MsoNormal>So, all the needed records in the selection are not updated.</P></DIV>
<DIV>
<P class=EC_MsoNormal>It would be of great help if I can set a control break so that every record in selection is updated.</P></DIV>
<DIV>
<P class=EC_MsoNormal>Correct me if I am going anywhere, or any other perfect way of updating such files.</P></DIV>
<DIV>
<P class=EC_MsoNormal>We have PowerHouse 8.43.D on Solaris SunOS.</P></DIV>
<DIV>
<P class=EC_MsoNormal> </P></DIV></DIV>
<DIV>
<P class=EC_MsoNormal>Thanks in advance.</P></DIV>
<DIV>
<P class=EC_MsoNormal> </P></DIV>
<DIV>
<P class=EC_MsoNormal>Regards,</P></DIV>
<DIV>
<P class=EC_MsoNormal>Vamsi<BR clear=all><BR>-- <BR>"Nothing is impossible as impossible itself says i m possible"</P></DIV>
<P class=EC_MsoNormal> </P>
<SPAN style="FONT-SIZE: 10pt">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><BR></DIV><BR>
<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><BR><br /><hr />Messenger wants to send you on a trip. <a href='http://www.messengerbuddies.ca/?ocid=BUDDYOMATICENCA21' target='_new'>Enter today.</a></body>
</html>