QTP in AXIANT 4GL

[Whittall, Conrad]

Hello Syed,

You can often improve performance of a PowerHouse application that used
to run against indexed files or non-relational databases when you
migrate them to run against a relational database by replacing some of
the data access with embedded SQL.

I'd suggest taking a look at the "PowerHouse and Relational Databases"
book as well as the "PowerHouse 4GL Migration Planning Guide for
MPE/iX". If you don't have copies of these you can download them from
the Cognos site at:

http://powerhouse.cognos.com/products/powerhouse/download.html

For your specific example I'd suggest creating a declared cursor that
uses the SQL to access, join, and select only the data you want passed
back from the database...then QTP simply has to access that declared
cursor. This offloads the majority of the data manipulation to the RDBMS
engine and will certainly improve performance, especially if
PowerHouse/Axiant is running on a different machine to the database. For
example...

SQL DECLARE c_transfers CURSOR FOR   &
   SELECT * <or simply a list of the columns you need> &
   FROM                              &
      TRANSFER-D,                    &
      COW-D,                         &
      COW-LOC-D,                     &
      UNIT-M                         &
   WHERE <you'll need to insert the SQL to join the tables together> &
     AND <then put in the SQL equivalent of your QTP SELECT statement>

ACCESS c_transfers


Best regards,
Conrad

Conrad Whittall
Senior Solutions Architect, Global Customer Services, Cognos
Incorporated
3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, Canada

-----Original Message-----
From: powerh-l-bounces+conrad.whittall=cognos.com at lists.sowder.com
[mailto:powerh-l-bounces+conrad.whittall=cognos.com at lists.sowder.com] On
Behalf Of Syed Shahul Hameed Mustaffa
Sent: Monday 8 August 2005 09:53
To: powerh-l at lists.sowder.com
Cc: Joe Boyle
Subject: QTP in AXIANT 4GL

Dear Gurus,

Quick Intro: I'm migrating PH/MPEIX application to AXIANT-4GL/WINDOWS.

The following QTP statement,

access TRANSFER-D  in cwdb                        &
         link to COW-D   in cwdb                 &
         link to COW-LOC-D    in cwdb            &
         link UNIT-NO of COW-LOC-D to UNIT-M  in cwdb

select TRANSFER-D if                              &
         TRNFR-DATE ge TRAN-DT-FR      and       &
         TRNFR-DATE le TRAN-DT-TO      and       &
         TRNFR-TYPE eq "U"             and       &
         TRNFR-SUB-TYPE eq "U"         and       &
         TRNFR-NEW-NO ge UNIT-NO-FR    and       &
         TRNFR-NEW-NO le UNIT-NO-TO

 is retrieving all the records of all the tables linked first and then
select specific records out of the entire set. I am have a relational db
(SQL SERVER). Is there any way stop this sequential access of all
records and only select those records I need.

Thanks & Best Regards,
SYED

--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = 
  
       This message may contain privileged and/or confidential information.  If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.  Thank you.