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