Element Type Definition: NON_ORACLE

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	NON_ORACLE_DATABASE
Short Name	ANS
View Name	CI_NON_ORACLE_DATABASES
Description	Definition of a non-Oracle database (eg Informix, RDB, DB2 etc)

Sub-type of	DATABASE
Versioning:	Structure of NON_ORACLE_DATABASE versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	NAME
Used by:	Oracle Designer
Underlying table:	SDD_ODB
Changes:	Summary of changes to NON_ORACLE_DATABASE in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
NODE_REFERENCE	Y	Prompt: Node Defined on ODB supertype	May be located at one and only one NODE

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
COMPLETE_FLAG	VARCHAR2(1)	N	Indicates whether the definition of this database is complete and ready to be used by the generators Prompt: Complete ? Uppercase Defined on ODB supertype	YESNO	Y
CONNECT_STRING	VARCHAR2(80)	Y	*Connect string to be used to connect to this database by SQLNet** Prompt: Connect String Defined on ODB supertype
DATABASE_TYPE	VARCHAR2(3)	N	Sub-type discriminator. Internal property indicating whether the DATABASE is an ORACLE_DATABASE (ORC) or a NON_ORACLE_DATABASE (ANS) Not displayed Uppercase System maintained Not updatable by user Defined on ODB supertype	ODB_DATABASE_TYPE
LOCAL_NAME	VARCHAR2(8)	N	Name of the database Prompt: Local Name Uppercase System maintained: API provides a value only if left null by the user Defined on ODB supertype
NAME	VARCHAR2(40)	N	Name that uniquely identifies the database in a distributed environment Prompt: Name Uppercase Defined on ODB supertype
NON_ORACLE_DATABASE_TYPE	VARCHAR2(16)	N	The database types, other than Oracle, supported by the server generator Prompt: Non-Oracle Database Type Uppercase	NON_ORACLE_DATABASE_TYPE Non-enforced
REMARK	VARCHAR2(240)	Y	A comment on the database. Prompt: Comment Defined on ODB supertype
TNS_ALIAS	VARCHAR2(40)	Y	*The alias for the TNS connection path, used by SQLNet v2** Prompt: TNS Alias Defined on ODB supertype

Multi-line Text
Name	Text Type	Prompt
DESCRIPTION	CDIDSC Defined on ODB supertype	Description
NOTES	CDINOT Defined on ODB supertype	Notes

Other Properties
NON_ORACLE_DATABASE has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility
The following 'standard' properties are also inherited by all element types: ID IRID IVID ELEMENT_TYPE_NAME DATE_CREATED CREATED_BY DATE_CHANGED CHANGED_BY NUMBER_OF_TIMES_MODIFIED TYPES

Other element types that reference NON_ORACLE_DATABASE:

Each FOLDER_MEMBER must be of one and only one FOLDERED_ELEMENT
Each DATABASE_USER must be on one and only one DATABASE
Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each DOCUMENT_ATTACHMENT must be from one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each TABLESPACE must be part of one and only one DATABASE
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be part of one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be use of one and only one ACCESS_CONTROLLED_ELEMENT

Note:

All properties are displayed and updatable by the user unless indicated otherwise

All reference properties are displayed and transferable unless indicated otherwise

All domains are enforced unless indicated otherwise

All properties and reference properties are defined on this element type unless indicated as inherited from a supertype