Powerhouse limits and enhancements

[Joe Boyle]

and there is always the result set from a stored procedure option, whreas 
Darren pointed out, the 'SP' can reference many files, but the cursor gets 
charged for only one,

run n1

global temp t_start_date char*8 parm
global temp t_end_date char*8  parm

req q1

SQL IN axnwind &
DECLARE EMPSKILLS CURSOR FOR &
CALL Employee_Sales_by_Country (t_start_date in, t_end_date in) &
RESULT SET &
Country VARCHAR(15), &
LastName VARCHAR(20), &
FirstName VARCHAR(10), &
ShippedDate datetime , &
OrderID int, &
SaleAmount money

acc eMPSKILLS



----- Original Message ----- 
From: "Joe Boyle" <atla38 at dsl.pipex.com>
To: "'Darren Reely - Lists'" <devlists at reely.com>; "'Brett Greiner'" 
<brett.greiner at synoptix.co.nz>
Cc: <powerh-l at lists.sowder.com>
Sent: Monday, July 16, 2007 7:49 PM
Subject: RE: Powerhouse limits and enhancements


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