Steffen Goeldner wrote:
> I'd like to remark that SQL/CLI has a more general function
>
> GetSessionInfo( ConnectionHandle, InfoType, ... )
>
> <general value specification> Data Type Code Information Type
> ------------------------------- ------------ -----
> -------------------------------
> USER and CURRENT_USER CHARACTER(L) 47 CURRENT USER
> CURRENT_DEFAULT_TRANSFORM_GROUP CHARACTER(L) 20004 CURRENT DEFAULT
> TRANSFORM GROUP
> CURRENT_PATH CHARACTER(L) 20005 CURRENT PATH
> CURRENT_ROLE CHARACTER(L) 20006 CURRENT ROLE
> SESSION_USER CHARACTER(L) 20007 SESSION USER
> SYSTEM_USER CHARACTER(L) 20008 SYSTEM USER
CURRENT_CATALOG CHARACTER(L) 20009 CURRENT CATALOG
CURRENT_SCHEMA CHARACTER(L) 20010 CURRENT SCHEMA
(The last 2 InfoType were missing in the previous post, sorry!)
Steffen