DB_ATTRIBUTE

Represents the attribute information of the class for which the current user has access authorization in the database.

Definition

CREATE VCLASS db_attribute (
attr_name, class_name, attr_type, def_order, from_class_name, from_attr_name, data_type, prec, scale, code_set, domain_class_name, default_value, is_nullable)
AS
SELECT a.attr_name, c.class_name,
       CASE WHEN a.attr_type = 0 THEN 'INSTANCE'
            WHEN a.attr_type = 1 THEN 'CLASS'
            ELSE 'SHARED' END,
       a.def_order, a.from_class_of.class_name, a.from_attr_name, t.type_name,
       d.prec, d.scale, d.code_set, d.class_of.class_name, a.default_value,
       CASE WHEN a.is_nullable = 0 THEN 'YES' ELSE 'NO' END
FROM _db_class c, _db_attribute a, _db_domain d, _db_data_type t
WHERE a.class_of = c AND d.object_of = a AND d.data_type = t.type_id AND
        (CURRENT_USER = 'DBA' OR
        {c.owner.name} subseteq (
                SELECT set{CURRENT_USER} + coalesce(sum(set{t.g.name}), set{})
                from db_user u, table(groups) as t(g)
                where u.name = CURRENT_USER ) OR
        {c} subseteq (
SELECT sum(set{au.class_of})
                FROM _db_auth au
                WHERE {au.grantee.name} subseteq (
                            SELECT set{CURRENT_USER} + coalesce(sum(set{t.g.name}), set{})
                            from db_user u, table(groups) as t(g)
                            where u.name = CURRENT_USER ) AND
                                    au.auth_type = 'SELECT'));

Example

• Example 1
• The following is an example of retrieving attributes and data types of the ‘event’ class.

csql> select attr_name, data_type, domain_class_name
csql> from db_attribute
csql> where class_name = 'event'
csql> order by def_order;
csql> ;xrun
 
=== <Result of SELECT Command in Line 1> ===
 
  attr_name             data_type             domain_class_name
==================================================================
  'code'                'INTEGER'             NULL
  'sports'              'STRING'              NULL
  'name'                'STRING'              NULL
  'gender'              'CHAR'                NULL
  'players'             'INTEGER'             NULL

• Example 2
• The following is an example of retrieving attributes of the ‘female_event’ class and its superclass.

csql> select attr_name, from_class_name
csql> from db_attribute
csql> where class_name = 'female_event'
csql> order by def_order;
csql> ;xrun
 
=== <Result of SELECT Command in Line 1> ===
 
  attr_name             from_class_name
============================================
  'code'                'event'
  'sports'              'event'
  'name'                'event'
  'gender'              'event'
  'players'             'event'

• Example 3
• The following is an example of retrieving classes whose attribute names are similar to 'name,' among the ones owned by the current user. (The user is PUBLIC.)

csql> select a.class_name, a.attr_name
csql> from db_class c join db_attribute a
csql> on c.class_name = a.class_name
csql> where c.owner_name = CURRENT_USER and
csql>       attr_name like '%name%'
csql> order by 1;
csql> ;xrun
 
=== <Result of SELECT Command in Line 1> ===
 
  class_name            attr_name
============================================
  'athlete'             'name'
  'code'                'f_name'
  'code'                's_name'
  'event'               'name'
  'female_event'        'name'
  'nation'              'name'
  'stadium'             'name'