Powerhouse limits and enhancements

[Joe Boyle]

now that you are moving to a RDB there is a  technique you can use, this 
will theoretically also allow you to have any number of file opens as 
appears to be the case with cisam.

You can use sql opens as below. If memory serves correctly these do not 
count as file opens in QTP, you can replace any 'output update/add' with 
either sql insert or sql add syntax and you should find your code will 
complile and run ok.

can cle

run n1

commit at request

req q1

acc order_details in axnwind alias inf
choose ProductID systemvalue("prodval)

define d_count  int*10 = 1 if Quantity lt 10

sql in axnwind if d_count = 1 update order_details &
set quantity = 1000 + quantity &
where OrderID = :OrderID of inf and ProductID = :ProductID of inf

etc...



----- Original Message ----- 
From: "Brett Greiner" <brett.greiner at synoptix.co.nz>
To: <powerh-l at lists.sowder.com>
Sent: Thursday, July 12, 2007 1:38 AM
Subject: Powerhouse limits and enhancements


>
>
> Hi all
>
> We are in the process of migrating from CISAM to DB2 RDBMS and when we
> have recomplied large QTP programs and have struct the file limit of 63
> for a run. It appears when using CISAM there is no file limit enforced.
> When the programs are changed over to use DB2 they no longer compile.
>
> compile :  ISDAILYDW starting to compile.
> Filename: /test/work/ISDAILYDW.er
> Errors/Warnings Found....
> Too many files declared for this run. QTP ending.
>
> Has anyone struct this issue before and how have you worked around it.
>
> There has been some discussion on enhancements to Powerhouse, extending
> this run limit would save us splitting up 15+ QTP programs. Prehaps
> increasing this limit to 255 would cope with all current programs.
>
> Thanks
> Brett
>
>
> Brett Greiner
> e: brett.greiner at synoptix.co.nz <mailto:brett.greiner at synoptix.co.nz>
>
> p: 0-6-759 1929
> w: www.synoptix.co.nz, www.intranetix.co.nz
> 30 Vivian Street, P.O. 997, New Plymouth
>
>
>
>
>
>
>
>
>
> -- 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> 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.
>