Tim Bunce wrote: > [...] > > Why not help save the world and help me add current_schema() to the DBI > and send implementations to the authors of drivers you're using?
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 (similar to GetInfo()). Translated to DBI , this would be $value = $dbh->get_session_info( $info_type ); Steffen