Re: sdd_elements no longer available in CASE6i. Plz help a student.

On Tue, 5 Jun 2001 08:48:49 -0600, "Melvin Tan" <mtan_at_hotmail.com> wrote:

>I am a student finally getting my hands dirty in Oracle and I've hit my
>first major technical roadblock. The database at this company was based on
>CASE6. But now that they've received Designer 6i, the database needs to be
>migrated to the new repository. That was done successfully. However, all
>the company reports that were done in Oracle Reports 6 does not work in
>Oracle Reports 6i because many of the queries were based on the sdd_elements
>and sdd_structured_elements. I've spent the better part of 3 days trying to
>find their equivalence in CASE6i, but so far no luck.
>
>Plz help me out if you can b/c I only have 1 more week to figure this out.
>
>Cheers, Melvin.
>
You are correct, SDD_Elements, and SDD_Structure_Elements are gone. It was never a good idea to write reports against these tables unless, you were trying to query across all element types. Oracle provides the CI views for each element type and its associations. These views are (mostly) unchanged in the 6i repository. The biggest change to the views in 6i is that none of the element types are directly related to CI_Application_Systems anymore. Instead, you need to query CI_Folder_Members, and if you're concerned about ownership, check the ownership_flag column.

If your current reports are only dealing with PAC (Primary Access Control - entities, table definitions, etc) elements, then you can use SDD_Object_Versions. SAC (Secondary Access) elements like attributes and columns are not in this view, however.

Good Luck!

Howard
For email, remove "nospam" from address.

[Quoted] -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Tue Jun 05 2001 - 20:44:36 CEST