Chapter 3 DBMS Reference Guide

Abstract Data Type

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%

 

Copyright (C) 2007. Sybase Inc. All rights reserved.