Updating Master File
Jaime A
jarqueza at gmail.com
Mon Dec 28 13:16:05 CST 2009
Hi Ken
Thanks for your prompt response. For using this method, it is assumed that
you'll be updating straight from the transaction file, right? What if you
need to access the master first, do some manipulation then update the
master. After the initial access and update, if I encounter another "U"pdate
transaction, will I be able to access the most current information (the one
that I have updated before) and do any manipulation? What should I do in
this case? Can I also do the addition and deletion (besides update) to the
master file all in one request?
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/20091228/30041ff0/attachment.htm
More information about the powerh-l
mailing list