Defining an extended attribute in a DBMS

Chapter 3 DBMS Resource File Reference

Defining an extended attribute in a DBMS

Each extended attribute has the following properties:

Property	Description
Name	Name of category or item.
Comment	Description of selected category or item.
Data type	Predefined or user-defined extended attributes types.
Default value	Default value from the list of values. Depends on the data type.

To add an extended attribute:

Right-click a metaclass category in the Profile category and select New→Extended Attributes from the contextual menu.

A new extended attribute is created.

Enter a name and comment, and then select a data type from the Data Type dropdown list box.

[optional] Select a default value in the Default Value list.

Click Apply.

Example

In DB2 UDB 7 OS/390, the extended attribute WhereNotNull allows you to add a clause enforcing the uniqueness of index names if they are not null.

In the Create index order, WhereNotNull is evaluated as follows:

create [%INDEXTYPE% ][%UNIQUE% [%WhereNotNull%?where not null ]]index [%QUALIFIER%]%INDEX% on [%TABLQUALIFIER%]%TABLE% (

%CIDXLIST%

)

[%OPTIONS%]

If the index name is unique, and if you set the type of the WhereNotNull extended attribute to True, the "where not null" clause is inserted in the script.

In the SqlListQuery item:

{OWNER, TABLE, INDEX, INDEXTYPE, UNIQUE, INDEXKEY, CLUSTER, WhereNotNull}

select 
   tbcreator,
   tbname,
   name,
   case indextype when '2' then 'type 2' else 'type 1' end,
   case uniquerule when 'D' then '' else 'unique' end, 
   case uniquerule when 'P' then 'primary' when 'U' then 'unique' else '' end, 
   case clustering when 'Y' then 'cluster' else '' end,
   case uniquerule when 'N' then 'TRUE' else 'FALSE' end
from
   sysibm.sysindexes 
where 1=1
[  and tbname=%.q:TABLE%]
[  and tbcreator=%.q:OWNER%]
[  and dbname=%.q:CATALOG%]
order by
   1 ,2 ,3