<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=us-ascii">
<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.EmailStyle18
{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'>See below<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>Jaime A<br>
<b>Sent:</b> December 29, 2009 2:07 PM<br>
<b>To:</b> powerh-l@lists.sowder.com<br>
<b>Subject:</b> [Bulk] Re: Update Master File<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'>Hi Ken<br>
<br>
I've tried and still getting error during compilation. Here is my situation:<br>
1. My Master file has two index key, one is activity_key
(partno+activitycode+activitydate+activitytime), this is defined as unique. The
other index key is a repeating index on partno.<br>
2. In one request, I have two outputs:<br>
i) output masterfile add update alias master1 viaindex
activity_key using partno of trans_file+<br>
activitycode of trans_file + activitydate of trans_file + activitytime of
trans_file &<br>
if transcode of trans_file = "U" or transcode of trans_file =
"A"<br>
ii) output masterfile delete alias master2 viaindex partno
using partno of trans_file &<br>
;
if activitycode of master2 = "D"<br>
if activitycode of masterfile = "D"<br>
For the above code, I got the following error:<br>
1. *E* Cant find the file for item named activitycode of master2.<br>
2. *W* Linkage should be via a unique index if the file is output only.<br>
<br>
Please could you help me to correct my program code? For the delete, I want to
delete those with the same partno and activitycode of master file =
"D". <br>
<br>
Thanks,<br>
Jaime<o:p></o:p></p>
<div>
<p class=MsoNormal>On Mon, Dec 28, 2009 at 10:00 AM, <<a
href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a>>
wrote:<o:p></o:p></p>
<p class=MsoNormal>Send powerh-l mailing list submissions to<br>
<a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a
href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:powerh-l-owner@lists.sowder.com">powerh-l-owner@lists.sowder.com</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of powerh-l digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. How to update a Master table (Jaime A)<br>
2. RE:[Bulk] How to update a Master table (Ken Langendock)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Sun, 27 Dec 2009 22:54:52 -0800<br>
From: Jaime A <<a href="mailto:jarqueza@gmail.com">jarqueza@gmail.com</a>><br>
Subject: How to update a Master table<br>
To: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>
Message-ID:<br>
<<a
href="mailto:3429621e0912272254h46477405gb0f24933ca10d323@mail.gmail.com">3429621e0912272254h46477405gb0f24933ca10d323@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
Hello,<br>
<br>
I want to process a transaction file and update the master file. The<br>
transaction file comes in with several transaction types which could be<br>
add<br>
(if not in master), update (if in master) or delete. There might be<br>
multiple update transaction which could depend on previous updates. So the<br>
processing<br>
should be done in a certain sequence based on how the events happening.
I<br>
know that if I use "Access Trans file link to Master File then do
an<br>
output<br>
at the end will give me an error as it will complain that I am accessing<br>
a<br>
record that has been updated". Please could somebody out
there expert in<br>
Powerhouse's QTP suggests how to code this program so I could do an<br>
add/update/delete (not in that order) without the error message?<br>
Thanks in advance,<br>
jamie<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a
href="http://lists.sowder.com/pipermail/powerh-l/attachments/20091227/bba2c28a/attachment-0001.html"
target="_blank">http://lists.sowder.com/pipermail/powerh-l/attachments/20091227/bba2c28a/attachment-0001.html</a><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Mon, 28 Dec 2009 12:48:16 -0500<br>
From: "Ken Langendock" <<a href="mailto:ken.langendock@rogers.com">ken.langendock@rogers.com</a>><br>
Subject: RE: [Bulk] How to update a Master table<br>
To: "'Jaime A'" <<a href="mailto:jarqueza@gmail.com">jarqueza@gmail.com</a>>,
<<a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>><br>
Message-ID: <000f01ca87e5$ef424a40$cdc6dec0$@<a
href="mailto:langendock@rogers.com">langendock@rogers.com</a>><br>
Content-Type: text/plain; charset="us-ascii"<br>
<br>
You need to access the master file in the output phase.<br>
<br>
<br>
<br>
Access TransFile<br>
<br>
<br>
<br>
Sort (if necessary)<br>
<br>
<br>
<br>
OUTPUT MasterFile &<br>
<br>
Add Update &<br>
<br>
NOITEMS & (if necessary)<br>
<br>
Via xxx using xxx<br>
<br>
<br>
<br>
Item xxx of MasterFile initial xxx of TransFile<br>
<br>
Item xxx of MasterFile FINAL xxx of TransFile<br>
<br>
Etc.<br>
<br>
<br>
<br>
<br>
<br>
That way it will update the master file for each transaction record and<br>
never give you the "record has changed since you found it" message.<br>
<br>
<br>
<br>
<br>
<br>
Ken<br>
<br>
<br>
<br>
From: powerh-l-bounces+ken.langendock=<a href="http://rogers.com"
target="_blank">rogers.com</a>@<a href="http://lists.sowder.com" target="_blank">lists.sowder.com</a><br>
[mailto:<a href="mailto:powerh-l-bounces%2Bken.langendock">powerh-l-bounces+ken.langendock</a>=<a
href="http://rogers.com" target="_blank">rogers.com</a>@<a
href="http://lists.sowder.com" target="_blank">lists.sowder.com</a>] On<br>
Behalf Of Jaime A<br>
Sent: December 28, 2009 1:55 AM<br>
To: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>
Subject: [Bulk] How to update a Master table<br>
<br>
<br>
<br>
Hello,<br>
<br>
I want to process a transaction file and update the master file. The<br>
transaction file comes in with several transaction types which could be<br>
add<br>
(if not in master), update (if in master) or delete. There might be<br>
multiple update transaction which could depend on previous updates. So the<br>
processing<br>
should be done in a certain sequence based on how the events happening.
I<br>
know that if I use "Access Trans file link to Master File then do
an<br>
output<br>
at the end will give me an error as it will complain that I am accessing<br>
a<br>
record that has been updated". Please could somebody out
there expert in<br>
Powerhouse's QTP suggests how to code this program so I could do an<br>
add/update/delete (not in that order) without the error message?<br>
Thanks in advance,<br>
jamie<br>
<br>
No virus found in this incoming message.<br>
Checked by AVG - <a href="http://www.avg.com" target="_blank">www.avg.com</a><br>
Version: 9.0.722 / Virus Database: 270.14.122/2590 - Release Date: 12/28/09<br>
02:16:00<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <a
href="http://lists.sowder.com/pipermail/powerh-l/attachments/20091228/f3fafd72/attachment-0001.htm"
target="_blank">http://lists.sowder.com/pipermail/powerh-l/attachments/20091228/f3fafd72/attachment-0001.htm</a><br>
<br>
------------------------------<br>
<br>
--<br>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>
Mailing list: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>
Subscribe: &quot;subscribe&quot; in message body to <a
href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>
Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in
message body to <a href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>
<a href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>
This list is closed, thus to post to the list you must be a subscriber.<br>
Add 'site:<a href="http://lists.sowder.com" target="_blank">lists.sowder.com</a>
powerh-l' to your search terms to search the list archive at Google.<br>
<br>
End of powerh-l Digest, Vol 55, Issue 5<br>
***************************************<o:p></o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>No virus
found in this incoming message.<br>
Checked by AVG - www.avg.com<br>
Version: 9.0.722 / Virus Database: 270.14.123/2592 - Release Date: 12/29/09
02:47:00</span><o:p></o:p></p>
</div>
</body>
</html>