Powerhouse C-ISAM to Oracle migration

[Stephen Corkill]

Hi Viet,

We tried that with no success.  Any other suggestions?

Stephen 

-----Original Message-----
From: powerh-l-bounces+stephen.corkill=synoptix.co.nz at lists.sowder.com
[mailto:powerh-l-bounces+stephen.corkill=synoptix.co.nz at lists.sowder.com
] On Behalf Of Viet Nguyen
Sent: Tuesday, 18 April 2006 7:01 a.m.
To: Jeff Hoffman; powerh-l at lists.sowder.com
Subject: RE: Powerhouse C-ISAM to Oracle migration

Jeff,
Try this ACCESS  ASSET_CATEGORY IN ORACLEDB (where ORACLEDB is the
connection name you defined in the pdl) 

-----Original Message-----
From: powerh-l-bounces+vnguyen=wsboces.org at lists.sowder.com
[mailto:powerh-l-bounces+vnguyen=wsboces.org at lists.sowder.com] On Behalf
Of Jeff Hoffman
Sent: Thursday, April 13, 2006 6:00 AM
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.