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