Re: Trying to locate view in the Designer Repository

In article <35F53EC1.31B0147D_at_formalsys.ca>,   prv <prv_at_formalsys.ca> wrote:
> Hi,
>
> I am trying to locate a column of information in the Designer
> Repository.
>
> If looking in the RON (Repository Object Navigator) a module has a
> description field and a notes fields.
>
> I tried locating these columns in the CI_MODULES view. It of course is
> not there. I tryied to look in the documentation for any foreign keys
> to this table to see if description or notes was in there, but had no
> luck.
>
> Does anyone know the name of the view that the description and notes are
> located in the Designer Repository.
>
> This reason I am looking for this information is because I am creating
> some API scripts. I am also using Oracle Designer version 1.3.2

The notes and comments fields are in a separate text table CDI_TEXT.

SQL> desc cdi_text

 Name                            Null?    Type
 ------------------------------- -------- ----
 TXT_REF                         NOT NULL NUMBER(38)
 TXT_SEQ                         NOT NULL NUMBER(6)
 TXT_TYPE                        NOT NULL VARCHAR2(6)
 TXT_TEXT                                 VARCHAR2(240)

TXT_REF joins to CDI_MODULES.ID. TXT_TYPE = 'CDIDSC' for descriptions and CDINOT for notes.

Hope this helps!

-Tim Hall, Indus International
email tim.hall (at) iint.com

http://www.indusword.com
http://ourworld.compuserve.com/homepages/timjh

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 09 1998 - 10:17:38 CEST