powerh-l Digest, Vol 43, Issue 10 - Agree with Gavin
Alan and Vicki
vical1 at eastlink.ca
Wed Dec 17 22:05:59 CST 2008
Agree with Gavin - not sure why you're putting an alias on your output
file -- QTP is now trying to find a linkage to it becuase it has to create
separate record buffers -- just drop the alias and allow it to update at
every record read (should also be faster). It is not creating any control
breaks because you are not using a choose or a sort -- it will just update
every record it reads....
Try it and let us know how it works!
Vicki
----- Original Message -----
From: <powerh-l-request at lists.sowder.com>
To: <powerh-l at lists.sowder.com>
Sent: Wednesday, December 17, 2008 2:20 PM
Subject: powerh-l Digest, Vol 43, Issue 10
> 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. RE:[Bulk] Help with QTP UPDATE (Lloyd, Gavin)
> 2. RE:[Bulk] Help with QTP UPDATE (Peter Bateman)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 17 Dec 2008 18:10:23 -0000
> From: "Lloyd, Gavin" <gavin.lloyd at fmglobal.com>
> Subject: RE: [Bulk] Help with QTP UPDATE
> To: "vamsi krishna" <vamsi.coe at gmail.com>, <powerh-l at lists.sowder.com>
> Message-ID:
> <C34A9B9BCDF37D4DA35BDCA5548A47D47FB85B at WINDEXCHP17.corp.fmglobal.com>
> Content-Type: text/plain; charset="utf-8"
>
> Correct me if I'm wrong but isn't the answer as simple as taking the
> alias off the output command:
>
>
>
> ACCESS OPTICLEN
> &
>
> LINK CUN
> &
>
> TO CUN OF *$PIC_DATA/OPBEUROD_S
> &
>
> LINK CRY OF OPBEUROD_S
> &
>
> TO CURR-CODE OF IPTIEURO
>
>
>
> SELECT IF CLAIM-CURR="SKK"
>
>
>
> OUTPUT OPTICLEN UPDATE
>
> ITEM CLAIM-CURR OF CLEN_UPD ="EUR"
>
>
>
> This way you will directly update the records that are being read rather
> than linking back to the record which is what the alias makes QTP do.
> My Powerhouse is getting rusty these days so excuse me if I've given
> dodgy advice!
>
>
>
> Regards,
> Gavin.
>
>
>
> From: Ken Langendock [mailto:ken.langendock at rogers.com]
> Sent: 17 December 2008 15:51
> To: 'vamsi krishna'; powerh-l at lists.sowder.com
> Cc: 'mRiDuLa'
> Subject: RE: [Bulk] Help with QTP UPDATE
>
>
>
> The problem is you are creating a record complex that may result in the
> same record being ready to update more than once.
>
>
>
> What you need to do is get the record complex down to One in and One
> out.
>
> Use output phase reading and move your select statement. And QUALIFY
> YOUR STATEMENTS
>
>
>
> Ken
>
>
>
> ACCESS OPTICLEN
>
>
>
> OUTPUT *$PIC_DATA/OPBEUROD_S &
>
> ADD &
>
> UPDATE &
>
> NOITEMS &
>
> IF 1 EQ 2 &
>
> VIA CUN &
>
> USING CUN OF OPTICLEN
>
>
>
>
>
> OUTPUT IPTIEURO &
>
> ADD &
>
> UPDATE &
>
> NOITEMS &
>
> IF 1 EQ 2 &
>
> VIA CURR-CODE &
>
> USING CRY OF OPBEUROD_S
>
>
>
>
>
> OUTPUT OPTICLEN &
>
> ALIAS CLEN_UPD &
>
> UPDATE &
>
> IF CLAIM-CURR OF IPTIEURO = "SKK"
>
>
>
> ITEM CLAIM-CURR OF CLEN_UPD FINAL "EUR"
>
>
>
>
>
> 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 vamsi krishna
> Sent: December 17, 2008 9:07 AM
> To: powerh-l at lists.sowder.com
> Cc: mRiDuLa
> Subject: [Bulk] Help with QTP UPDATE
>
>
>
> Hi All,
>
>
>
> I need to update an indexed file which has no unique key, but all
> "repeating primary" and "repeating alternate" indexes.
>
>
>
>
>
> When i compile the program, I get the following warning:
>
> *W* Linkage should be via a unique key/index if the file is output only.
>
>
>
> Program is something like this:
>
>
>
> ACCESS OPTICLEN
> &
>
> LINK CUN
> &
>
> TO CUN OF *$PIC_DATA/OPBEUROD_S
> &
>
> LINK CRY OF OPBEUROD_S
> &
>
> TO CURR-CODE OF IPTIEURO
>
>
>
> SELECT IF CLAIM-CURR="SKK"
>
>
>
> OUTPUT OPTICLEN ALIAS CLEN_UPD UPDATE
>
> ITEM CLAIM-CURR OF CLEN_UPD ="EUR"
>
>
>
> 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.
>
> So, all the needed records in the selection are not updated.
>
> It would be of great help if I can set a control break so that every
> record in selection is updated.
>
> Correct me if I am going anywhere, or any other perfect way of updating
> such files.
>
> We have PowerHouse 8.43.D on Solaris SunOS.
>
>
>
> Thanks in advance.
>
>
>
> Regards,
>
> Vamsi
>
> --
> "Nothing is impossible as impossible itself says i m possible"
>
>
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.552 / Virus Database: 270.9.18/1852 - Release Date:
> 16/12/2008 6:11 PM
>
>
>
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.552 / Virus Database: 270.9.18/1852 - Release Date:
> 16/12/2008 6:11 PM
>
>
>
> Registered No. 755780 England
> Registered Office: FM Insurance Company Limited
> 1 Windsor Dials, Windsor,
> Berkshire, UK, SL4 1RS
> Regulated by the Financial Services Authority.
> VAT No. G.B.: 792 4276 02
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.sowder.com/pipermail/powerh-l/attachments/20081217/285a775f/attachment-0001.htm
>
> ------------------------------
>
> Message: 2
> Date: Wed, 17 Dec 2008 14:20:12 -0400
> From: Peter Bateman <peterbateman808 at hotmail.com>
> Subject: RE: [Bulk] Help with QTP UPDATE
> To: vamsi krishna <vamsi.coe at gmail.com>, PowerHouse List
> <powerh-l at lists.sowder.com>
> Cc: mridulap2003 at gmail.com
> Message-ID: <BAY133-W4117B67C10AD89036000ABF9F20 at phx.gbl>
> Content-Type: text/plain; charset="iso-8859-1"
>
>
> Hi Vamsi
>
> Is there a unique combination of index and other item values?
>
> If so you can specify an access path with a select on it!
>
> e.g.
>
> OUTPUT OPTICLEN &
> ALIAS CLEN_UPD &
> UPDATE &
> VIA <key item> USING <key Value> &
> IF CLAIM-CURR OF IPTIEURO = "SKK"
>
> SELECT CLEN_UPD IF <other item> = <other item value>
>
> ITEM CLAIM-CURR OF CLEN_UPD FINAL "EUR"
>
> Regards,
> Peter Bateman
>
>
>
>
> From: ken.langendock at rogers.comTo: vamsi.coe at gmail.com;
> powerh-l at lists.sowder.comSubject: RE: [Bulk] Help with QTP UPDATEDate:
> Wed, 17 Dec 2008 10:50:48 -0500CC: mridulap2003 at gmail.com
>
>
>
> The problem is you are creating a record complex that may result in the
> same record being ready to update more than once.
>
> What you need to do is get the record complex down to One in and One out.
> Use output phase reading and move your select statement. And QUALIFY YOUR
> STATEMENTS
>
> Ken
>
> ACCESS OPTICLEN
>
> OUTPUT *$PIC_DATA/OPBEUROD_S &
> ADD &
> UPDATE &
> NOITEMS &
> IF 1 EQ 2 &
> VIA CUN &
> USING CUN OF OPTICLEN
>
>
> OUTPUT IPTIEURO &
> ADD &
> UPDATE &
> NOITEMS &
> IF 1 EQ 2 &
> VIA CURR-CODE &
> USING CRY OF OPBEUROD_S
>
>
> OUTPUT OPTICLEN &
> ALIAS CLEN_UPD &
> UPDATE &
> IF CLAIM-CURR OF IPTIEURO = "SKK"
>
> ITEM CLAIM-CURR OF CLEN_UPD FINAL "EUR"
>
>
>
> 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 vamsi krishnaSent: December 17, 2008 9:07 AMTo:
> powerh-l at lists.sowder.comCc: mRiDuLaSubject: [Bulk] Help with QTP UPDATE
>
> Hi All,
>
>
>
> I need to update an indexed file which has no unique key, but all
> "repeating primary" and "repeating alternate" indexes.
>
>
>
>
>
> When i compile the program, I get the following warning:
>
>
> *W* Linkage should be via a unique key/index if the file is output only.
>
>
>
> Program is something like this:
>
>
>
>
>
> ACCESS OPTICLEN &
>
> LINK CUN &
>
> TO CUN OF *$PIC_DATA/OPBEUROD_S &
>
> LINK CRY OF OPBEUROD_S &
>
> TO CURR-CODE OF IPTIEURO
>
>
>
>
> SELECT IF CLAIM-CURR="SKK"
>
>
>
> OUTPUT OPTICLEN ALIAS CLEN_UPD UPDATE
>
>
> ITEM CLAIM-CURR OF CLEN_UPD ="EUR"
>
>
>
> 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.
>
> So, all the needed records in the selection are not updated.
>
> It would be of great help if I can set a control break so that every
> record in selection is updated.
>
> Correct me if I am going anywhere, or any other perfect way of updating
> such files.
>
> We have PowerHouse 8.43.D on Solaris SunOS.
>
>
>
> Thanks in advance.
>
>
>
> Regards,
>
> Vamsi-- "Nothing is impossible as impossible itself says i m possible"
>
> No virus found in this incoming message.Checked by AVG.Version: 7.5.552 /
> Virus Database: 270.9.18/1852 - Release Date: 16/12/2008 6:11 PM
> No virus found in this outgoing message.Checked by AVG.Version: 7.5.552 /
> Virus Database: 270.9.18/1852 - Release Date: 16/12/2008 6:11 PM
> _________________________________________________________________
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.sowder.com/pipermail/powerh-l/attachments/20081217/f92039e7/attachment.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 43, Issue 10
> ****************************************
>
More information about the powerh-l
mailing list