Powerhouse C-ISAM to Oracle migration

[Peter Bateman]

I agree with Ken. It looks like a timeout problem.
try SQLTRACE to find out what is happening.

Also try setting the OWNER run time parameter.

I have found if I loaded my diictionary with elements that were the same
name and type as in my database PowerHouse ran faster.

This I believe was because it used less DB resources to construct the
item list.

Regards,
Peter

>Try specifying NODELAY on the Search= statement.
>
>Ken
>
>
>-----Original Message-----

>To: powerh-l at lists.sowder.com
>Subject: RE: Powerhouse C-ISAM to Oracle migration
>
>
>Hi
>
>Have you check the case of the fields and table names?
>
>Jeff
>
>At 11:58 AM 13/04/2006, you wrote:
> >Content-class: urn:content-classes:message
> >Content-Type: multipart/alternative;
> >         boundary="----_=_NextPart_001_01C65E9D.B7FA3BC9"
> >
> >Hello everyone,
> >
> >We in the process of mapping out the migration of Powerhouse
>applications
> >(v 8.13.D2) from C-ISAM to Oracle 8.17 on AIX 5.  We have setup a
>sample
> >of the tables within Oracle and can access these from Powerhouse if we
> >define a CURSOR.  However we are having trouble accessing tables via a
> >nomal "Access" statement.  Below is an example where a CUROSR works,
>but
> >the "access ASSET_CATEGORY" takes 2-3 seconds before exits QUIZ with no
>
> >error message.  "Access ASSET_CATEGORY_X", which should produce a error
>
> >message because not table of this exists also causes quiz to exit
>without
> >an error message.
> >
> >Any ideas on where to start looking at where the problem would be?
> >
> >Regards, Stephen
> >
> >---------------
> >
> >SYS=/live|steve:/home/steve>quiz SUBDICT=SEARCH
> >Q U I Z   (PowerHouse  8.13.D2)
> >Copyright 1999 COGNOS INCORPORATED
> >Licensed PH8-TEMPORARY for customer: 0712570003 COGNOS HU DEMO
> >
> >Warning: Temporary licensing of PowerHouse Server products expires
> >15-MAY-2006.
> >Please contact your local Sales Administration office for a permanent
>license.
> >
> > > SQL DECLARE TEST_CURSOR CURSOR FOR SELECT * FROM ASSET_CATEGORY
> > > access TEST_CURSOR
> > > go
> >
> >Records selected:  1
> >
> > > access ASSET_CATEGORY
> >SYS=/live|steve:/home/steve>
> >--
> >= = = = = = = = = = = = = = = = = = = = = = = = = = = =
> >Mailing list: powerh-l at lists.sowder.com
> >Subscribe: "subscribe" in message body to
>powerh-l-request at lists.sowder.com
> >Unsubscribe: "unsubscribe <password>" 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.
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to
>powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe <password>" 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.
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe <password>" 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.

_________________________________________________________________
Take advantage of powerful junk e-mail filters built on patented Microsoft® 
SmartScreen Technology. 
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSN® Premium right now and get the 
first two months FREE*.