Thanks for looking at this, Rick!
1) I was under the impression I had to provide a (dummy)
implementation of VTICosting, thank for letting me know I don't.
2) It will perhaps be good to add an ORDER BY clause to the
implementation of ij "show enabled_roles". Presently, the current role
is returned first; the rest of the rows do not have a defined order.
Another thing; the present "show role" command shows all roles defined
in the database (similar to show tables etc). Perhaps it would be
useful to have a command to show the roles which are settable for the
session (union of those granted to the current user and to PUBLIC)? I don't
find that information as a predefined view in the "definition schema"
of volume 11, though.
But there are many other views pertaining to roles in the definition
schema: ROLE_COLUMN_GRANTS, ROLE_ROUTINE_GRANTS, ROLE_TABLE_GRANTS,
ROLE_TABLE_METHOD_GRANTS, ROLE_USAGE_GRANTS, ROLE_UDT_GRANTS,
APPLICABLE_ROLES, and ADMINISTRABLE_ROLE_AUTHORIZATIONS, and the
*_PRIVILEGES views also consider the current role.
I am not sure I have an itch to add all of these now, but it would be nice
to get a feeling for if the approach of adding such views as VTIs is
sound. Is the schema SYSCS_DIAG ok or do we need a new one?