PH840d odd behaviour

Johnson, Harold A EDUC:EX Harold.A.Johnson@gems1.gov.bc.ca
Fri, 18 Mar 2005 14:54:26 -0800


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