<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<HTML><HEAD><TITLE>Synoptix Limited</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<STYLE type=text/css>.style1 {
FONT-SIZE: 12px; COLOR: #333333; FONT-FAMILY: Arial, Helvetica, sans-serif
}
</STYLE>
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY><FONT face=Arial size=2>
<P>Hello everyone,</P></FONT>
<P><FONT face=Arial size=2><SPAN class=774335523-12042006>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<FONT color=#ff0000><STRONG>_X</STRONG></FONT>", which
should produce a error message because not table of this exists also causes
quiz to exit without an error message.</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN class=774335523-12042006>Any ideas on where to
start looking at where the problem would be?</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN class=774335523-12042006>Regards,
Stephen</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
class=774335523-12042006>---------------</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
class=774335523-12042006>SYS=/live|steve:/home/steve>quiz SUBDICT=SEARCH<BR>Q
U I Z (PowerHouse 8.13.D2)<BR>Copyright 1999 COGNOS
INCORPORATED<BR>Licensed PH8-TEMPORARY for customer: 0712570003 COGNOS HU
DEMO</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN class=774335523-12042006>Warning: Temporary
licensing of PowerHouse Server products expires 15-MAY-2006.<BR>Please contact
your local Sales Administration office for a permanent
license.</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN class=774335523-12042006>> SQL DECLARE
TEST_CURSOR CURSOR FOR SELECT * FROM ASSET_CATEGORY<BR>> access
TEST_CURSOR<BR>> go</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN class=774335523-12042006>Records
selected: 1</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN class=774335523-12042006>> access
ASSET_CATEGORY<BR>SYS=/live|steve:/home/steve></SPAN></FONT></P></BODY></HTML>