Help with QTP UPDATE

vamsi krishna vamsi.coe at gmail.com
Wed Dec 17 08:06:55 CST 2008


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"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20081217/005618d8/attachment.htm 


More information about the powerh-l mailing list