Element Type Definition: SQL_QUERY

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	SQL_QUERY_SET
Short Name	SQS
View Name	CI_SQL_QUERY_SETS
Description	A SQL query set represents a SQL statement involved in a set
	operation with the main SQL statement defined via a module component.

	In the following example,

	(SQL statement A) UNION (SQL statement B) UNION (SQL statement C)

	SQL statements B and C are SQL query sets

	SQL statement A is represented by the MODULE_COMPONENT (as are all
	"normal" SQL statements not involving set operations).

	In Designer/2000 Release 2.0, UNION is the only set operator supported

Sub-type of	SECONDARY_ACCESS_ELEMENT
Versioning:	Belongs to: GENERAL_MODULE versionable object REUSABLE_LOV versionable object REUSABLE_MCO versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	MODULE_COMPONENT_REFERENCE LIST_OF_VALUES_REFERENCE NAME
Used by:	Oracle Designer
Underlying table:	SDD_SQS
Changes:	Summary of changes to SQL_QUERY_SET in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
LIST_OF_VALUES_REFERENCE	N	Prompt: List of Values Transferable only if null	Must be inset operation with one and only one LIST_OF_VALUES	83
MODULE_COMPONENT_REFERENCE	N	Prompt: Module Component Transferable only if null	Must be in set operation with one and only one MODULE_COMPONENT	83

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
NAME	VARCHAR2(30)	N	Name by which this SQL query set is identified Prompt: Name Uppercase System maintained: API provides a value only if left null by the user
SEQUENCE_NUMBER	NUMBER(6, 0)	N	Sequence of the SQL statement within the set of queries involved in the set operation Prompt: Usage Sequence System maintained: API provides a value only if left null by the user
SQL_QUERY_SET_FOR	VARCHAR2(3)	N	Arc 83 discriminator. Indicates whether SQL belongs to a module component or a list of values Not displayed Uppercase System maintained Not updatable by user	SQL_QUERY_SET_FOR
PARENT_IVID	NUMBER(38, 0)	Y	Internal use only. Exists on "secondary" element types from a versioning viewpoint. Contains the IVID of the primary element type (not necessarily a PAC) forming the basis of the "versionable object" to which this element type belongs Not displayed System maintained Updatable only if null Defined on SAC supertype
PAC_REFERENCE	NUMBER(38, 0)	Y	Internal use only. Exists on "secondary" element types from a structural viewpoint. Contains the IRID of the PAC forming the basis of the "logical object" to which this element type belongs Not displayed System maintained Not updatable by user Defined on SAC supertype

Multi-line Text
Name	Text Type	Prompt
DESCRIPTION	CDIDSC	Description
NOTES	CDINOT	Notes

Other Properties
SQL_QUERY_SET 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 SQL_QUERY_SET:

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 ITEM must be within one and only one SQL_QUERY_SET (in arc)
Each MODULE_DETAIL_TABLE_USAGE must be within one and only one SQL_QUERY_SET (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