PH840d odd behaviour

[Deskin, Bob]

Please report this to Cognos Customer Support so we can get the details and investigate properly.

Bob Deskin              
Senior Product Manager, Application Development Tools
Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA
bob.deskin@cognos.com (613) 738-1338 ext 7268

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Johnson, Harold A
EDUC:EX
Sent: March 18, 2005 5:54 PM
To: PowerHouse List
Subject: PH840d odd behaviour


Hi All.  We are moving to PH840d, but i've uncovered some strange behaviour
in regards to compiling a quick screen (quiz exibits the same behaviour)
that accesses a table in an oracle 8i database.  

ie:

screen xxx
file	view1 in oracle_database primary
etc..


When I compile this program, it hangs on the "file" statement.  My DBA's
looked at the access into the Oracle DB and found that it was doing a:

"select * from view1"

No wonder it's hanging!  The view1 hits a very large set of tables.

What's going on?  Shouldn't it just get the view definition and NOT the
data?   This compile/process works fine in 830d.  It also is fine in our
deve and test environments because of a much smaller set of data than
production.

OpenVMS 7.3
ORacle RDB 7.1
Powerhouse 840d
@setoracle9i

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request@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. 
  
       This message may contain privileged and/or confidential information.  If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.  Thank you.