Represents method information. Indexes for class_of and meth_name are created.
Attribute Name |
Data Type |
Description |
---|---|---|
class_of |
_db_class |
Class to which the method belongs |
meth_type |
INTEGER |
Type of the method defined in the class. 0 for an instance method, and 1 for a class method. |
from_class_of |
_db_class |
If the method is inherited, the super class in which it is defined is used otherwise NULL |
from_meth_name |
VARCHAR(255) |
If the method is inherited and its name is changed to resolve a name conflict, the original name defined in the super class is used otherwise NULL |
meth_name |
VARCHAR(255) |
Method name |
signatures |
SEQUENCE OF _db_meth_sig |
C function executed when the method is called |
The following example shows how to retrieve class methods of the class with a class method (c.class_meth_count > 0), among classes owned by user 'DBA.'
SELECT class_name, SEQUENCE(SELECT meth_name
FROM _db_method m
WHERE m in c.class_meths)
FROM _db_class c
WHERE c.owner.name = 'DBA' AND c.class_meth_count > 0
ORDER BY 1;
class_name sequence((select meth_name from _db_method m where m in c.class_meths))
============================================
'db_serial' {'change_serial_owner'}
'db_authorizations' {'add_user', 'drop_user', 'find_user', 'print_authorizations', 'info', 'change_owner', 'change_trigg
r_owner', 'get_owner'}
'db_authorization' {'check_authorization'}
'db_user' {'add_user', 'drop_user', 'find_user', 'login'}
'db_root' {'add_user', 'drop_user', 'find_user', 'print_authorizations', 'info', 'change_owner', 'change_trigg
r_owner', 'get_owner', 'change_sp_owner'}