Chapter 3 DBMS Reference Guide


Common entries for Abstract Data Type

You can define values for the following common entries for the Abstract Data Types object in the DBMS definition.

Entry Example
Enable Sybase Adaptive Server Anywhere 6:

Enable = Yes
Create In Oracle 8:

[%ISARRAY% ? create type %ADT% as %TYPE% (%SIZE%) of %DATATYPE%]
[%ISLIST%   ? create type %ADT% as %TYPE% of %DATATYPE%]
[%ISOBJECT% ? create type %ADT% as %TYPE%
(
%ADTDEF%
)]
Drop In Oracle 8:

drop type %ADT%
SqlListQuery In Sybase Adaptive Server Anywhere 6:

{ADT, OWNER, TYPE(25=JAVA , 26=JAVA)}
SELECT t.type_name, u.user_name,  t.domain_id
FROM sysusertype t, sysuserperms u
WHERE [u.user_name = '%SCHEMA%' AND]
(domain_id = 25 OR domain_id = 26) AND
t.creator = u.user_id
ORDER BY type_name
SqlAttrQuery
ModifiableAttributes List of extended attributes that will be taken into account in the merge dialog box during database synchronization
ReversedStatements List of statements that will be reverse engineered

For a description of each of the common object entries, see section "Common object entries".

 


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