Abstract Data Type Category (DBMS)

The Abstract Data Type category is located in the Root > Script > Objects category, and can contain the following items that define how abstract data types are modeled for your DBMS.

Item

Description

[Common items]

The following common object items may be defined for abstract data types:

  • AfterCreate, AfterDrop, AfterModify

  • BeforeCreate, BeforeDrop, BeforeModify

  • Create, Drop

  • Enable

  • ModifiableAttributes

  • Permission

  • ReversedQueries, ReversedStatements

  • SqlAttrQuery, SqlListQuery, SqlPermQuery

For a description of each of these common items, see Common Object Items.

ADTComment

Specifies a statement for adding an abstract data type comment.

AllowedADT

Specifies a list of abstract data types which can be used as data types for abstract data types.

Example (Oracle 10g):

OBJECT
TABLE
VARRAY

Authorizations

Specifies a list of those users able to invoke abstract data types.

CreateBody

Specifies a statement for creating an abstract data type body.

Example (Oracle 10g):

create [or replace ]type body [%QUALIFIER%]%ADT% [.O:[as][is]]
 %ADTBODY%
end;

EnableAdtOn Coln

Specifies whether abstract data types are enabled for columns. The following settings are available:

  • Yes - Abstract Data Types are added to the list of column types provided they have the valid type.

  • No - Abstract Data Types are not allowed for columns.

EnableAdtOn Domn

Specifies whether abstract data types are enabled for domains. The following settings are available:

  • Yes - Abstract Data Types are added to the list of domain types provided they have the valid type

  • No - Abstract Data Types are not allowed for domains

Enable Inheritance

Enables inheritance for abstract data types.

Install

Specifies a statement for installing a Java class as an abstract data class (in ASA, abstract data types are installed and removed rather than created and deleted). This item is equivalent to a create statement.

Example (SQL Anywhere 10):

install JAVA UPDATE from file %.q:FILE%

JavaData

Specifies a list of available instantiation mechanisms for SQL Java abstract data types.

Remove

Specifies a statement for installing a Java class as an abstract data class.

Example (SQL Anywhere 10):

remove JAVA class %ADT%
Parent topic: Script/Objects Category (DBMS)