More Probs in 8.40D

[brian_matthewsbrian matthews]

as a work around, could you not create empty tables in a database copy, 
along with a pdl source and dictionary pointing at the copy, and compile 
against that ? if only the source files pointing at large tables.

regards Bri,

>From: "Johnson, Harold A EDUC:EX" <Harold.A.Johnson@gov.bc.ca>
>To: powerh-l@lists.sowder.com
>Subject: More Probs in 8.40D
>Date: Tue, 5 Apr 2005 09:21:30 -0700
>
>OpenVMS 7.3
>OracleRDB 7.1
>
>Oracle 8i on some other box.
>
>Hi all.   I've opened a new problem with Cognos on Mar.25th:
>
>Subject: RE: [Call Reference: 3246754] Strange behaviour
>
>We have a couple of specific processes that hit an Oracle8i database (read
>only).  I have a very strange problem and was wondering if anyone else has
>seen this or can duplicate it.
>
>
>In PH830d, using quiz, the command "access <view> in <oracledb>"  actually
>runs the code:
>
>SELECT A.TABLE_NAME,A.INDEX_NAME,
>A.UNIQUENESS,B.COLUMN_POSITION,B.COLUMN_NAME
>FROM ALL_INDEXES A, ALL_IND_COLUMNS B
>WHERE A.TABLE_OWNER = :owner1 AND A.TABLE_NAME IN ( :name1 ) AND A.OWNER =
>B.INDEX_OWNER AND A.INDEX_NAME = B.INDEX_NAME
>ORDER BY A.UNIQUENESS DESC, A.INDEX_NAME, B.COLUMN_POSITION
>
>In PH840d, using quiz, the same command runs the code:
>
>SELECT * FROM <view>
>
>
>As you can probably guess, I can't compile any programs properly (quiz, qts
>or quick) because it's actually getting the data instead of the meta data.
>This has been verified by our DBA.  The compile eventually completes, but 
>it
>takes a long time (hours).   We didn't notice it in deve or test because of
>the small database size.   Only in production was this problem found.
>
>???
>
>signed Dazed and Confuzed.
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
>Unsubscribe: "unsubscribe &lt;password&gt;" 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