Powerhouse limits and enhancements

[Joe Boyle]

Many apologies Brett(et al),

my suggestion that PH SQL DML calls do not count as file opens is incorrect.
I misread a comment in an old Axiant/SQL paper. It seems that the 'theory'
was mooted as a question, and not intended to be interpreted as an
alternative coding technique.

I 'now' prefer to think that ( if there had been any point in doing it )
there may be as much work in redeclaring file statements as DML statements,
as there is in splitting the QTP runs.

You could rewrite the qtp runs as qdesign/quick batch jobs, but this would
only help if the number of input files per QTP run is 31 or less. You could
run all the output file deletes/inserts/updates as full SQL DML commands by
first writing them to SQL command files and then invoking them via the 'run
command',

e.g. in Oracle

get param_file_1 using...
let t_command = &
'echo  >> mycomms_1.sql ' + ' update order_details ' + &
'set quantity = 10 * quantity where orderid = ' + &
para_n of param_file_1
run command t_command
...
run command t_command
...
run command "sqlplus user2/user2 at daimler73 < mycomms_1.sql "


get param_file_31 using...
let t_command = &
'echo  >> mycomms_31.sql ' + ' delete from order_details ' + & 
where orderid = ' + para_n of param_file_31
run command t_command
...
run command t_command
...
run command "sqlplus user2/user2 at daimler73 < mycomms_31.sql "

Joe.

-----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
Joe Boyle
Sent: 14 July 2007 13:43
To: Brett Greiner; powerh-l at lists.sowder.com
Subject: Re: Powerhouse limits and enhancements

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

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