[Bulk] Re: Update Master File

Tue Dec 29 13:25:47 CST 2009

See below

From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Jaime A
Sent: December 29, 2009 2:07 PM
To: powerh-l at lists.sowder.com
Subject: [Bulk] Re: Update Master File

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"
                                         if activitycode of masterfile = "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/att
achment-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
<mailto: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/att
achment-0001.htm

------------------------------

--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: &quot;subscribe&quot; in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; 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
***************************************

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.722 / Virus Database: 270.14.123/2592 - Release Date: 12/29/09
02:47:00

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20091229/25707223/attachment-0001.htm 