Powerhouse limits and enhancements

[Joe Boyle]

Many thanks Darren, that explains the comment I saw in terms of input files,
I had assumed the discussion was related to output files and DML.

-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Darren Reely - Lists
Sent: 16 July 2007 02:38
To: Brett Greiner
Cc: powerh-l at lists.sowder.com
Subject: Re: Powerhouse limits and enhancements

One possibility is for your selection data, use cursors where you  
can. A cursor is counted as one file statement.

On Jul 11, 2007, at 5:38 PM, Brett Greiner wrote:

>
>
> 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.

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.