PH840d odd behaviour

[brian_matthewsbrian matthews]

as a work around I suspect that if you use declare cursor syntax, only the 
columns referenced in the cursor wiil be returned, otherwise the program has 
no idea which columns you want to access and will get them all ?

Why it works well in 8.30.C is beyond me. If you specify 'set list sql' in 
your source code you will see  what will be returned without the need of 
your DBA, but this might not apply to 'file' syntax.


You could always type 'show items' in quiz ( after 'access view1' ) in 
8.30.c and then again in 8.40.d to see if they are listing different items.

regards Bri,


>From: "Johnson, Harold A EDUC:EX" <Harold.A.Johnson@gems1.gov.bc.ca>
>To: PowerHouse List <powerh-l@lists.sowder.com>
>Subject: PH840d odd behaviour
>Date: 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
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>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.

_________________________________________________________________
Use MSN Messenger to send music and pics to your friends 
http://www.msn.co.uk/messenger