More Probs in 8.40D

[brian_matthewsbrian matthews]

even if you mapped only the problem/large tables in the copy database, you 
could use syntax like that below - as long as you use 'subdict=search' the 
compilers should fall through to the second database when searching for 
tablenames not mapped in the first ( you would have only the live database 
mapped in the live dictionary )

database smallDB...
database alltablesDB ...

regards Bri,


>From: "brian_matthewsbrian matthews" <brian_matthews_bmw@hotmail.com>
>To: Harold.A.Johnson@gov.bc.ca, powerh-l@lists.sowder.com
>Subject: RE: More Probs in 8.40D
>Date: Tue, 05 Apr 2005 21:49:26 +0000
>
>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
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>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.

_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! 
http://www.msn.co.uk/messenger