Powerhouse migration questions

[Joe Boyle]

Axiant might be useful in that it provides a GUI interface in terms of
creating linkages - but this is limited to screen design (and to Quiz). 

There is nothing created by default when creating QTP runs within Axiant,
you are literally faced with a blank screen; when working with Axiant I used
to create my default access statements with Quiz and then cut and paste them
into QTP.

Regards, Joe.

This e-mail and all information contained in it is confidential and may be
legally privileged. If you are not the intended recipient, your access to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. The content of this e-mail and any
attachments sent with it may have been altered without the consent or
knowledge of the author.


-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Robert Edis
Sent: 12 January 2005 20:40
To: PowerHouse List
Subject: RE: Powerhouse migration questions

Does Axiant have such a tool?  I know it is good for
converting non-relational to relational syntax in PH
code.

Blue
--- Viet Nguyen <VNguyen@wsboces.org> wrote:

> Hi ,
> I am in the process of moving from cisam to oracle
> using AIX - (we are
> keeping powerhouse in Unix) I would like to know if
> anyone out there has
> a parser or a smart search/replace routine to help
> with converting the
> Access statement otherwise I think it will take us
> forever to manually
> make these changes!
> Thanks in advance.
> Viet.
> 
> 
> -----Original Message-----
> From: powerh-l-admin@lists.sowder.com
> [mailto:powerh-l-admin@lists.sowder.com] On Behalf
> Of Jon Kvisli
> Sent: Wednesday, January 12, 2005 10:00 AM
> To: Pat Shugart; powerh-l@lists.sowder.com
> Subject: SV: QTP migration questions
> 
> >We're not replacing Powerhouse. 
>  
> Then I strongly advise you to KEEP your QTP
> programs, but spend some
> time optimizing ACCESS statements using cursors and
> SQL. This advise is
> based on personal, practical experience from
> converting two large
> systems (2-300 QTPs) from HP3000/Image to
> HP9000/Oracle. We then
> searched for other / better batch-processig tools,
> but finally decided
> to stay with QTP.
>  
> However, you WILL have to do changes in the QTP
> source. Due to the way
> QTP interacts with a relational database, most QTPs
> will do a high
> number of SQL-calls and perform VERY bad if ACCESS
> statements are left
> unchanged. The big issue is to let the
> databaseserver do most of the job
> by extracting only the data needed by QTP (that is
> moving functionality
> into the database). This will reduce the number of
> SQL calls from QTP to
> Oracle, and also reduce network traffic returning
> data back to QTP. If
> you do a good job rewriting ACCESS statements using
> cursors and SQL, you
> will most likely get performance that is even much
> better than the
> original qtp. 
>  
> Another way of moving functionality into the
> database, is using stored
> procedures in PL/SQL, but this is more useful for
> moving business logic
> away from QDESIGN/QUICK programs, than with QTP.
>  
> regards
> Jon Kvisli
> principal consultant
> 3800 Bo in Telemark
> Norway
> jon.kvisli@exchangemail.no
>  
>  
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = =
> = =
> Mailing list: powerh-l@lists.sowder.com
> Subscribe: "subscribe" in message body to
> powerh-l-request@lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message
> body to
> powerh-l-request@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.
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = =
> = =
> Mailing list: powerh-l@lists.sowder.com
> Subscribe: "subscribe" in message body to
> powerh-l-request@lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message
> body to powerh-l-request@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.
> 

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@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.