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

Reply via email to