Powerhouse C-ISAM to Oracle migration

[Stephen Corkill]

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>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060413/c7615e84/attachment.html