Powerhouse C-ISAM to Oracle migration

[Jeff Hoffman]

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.