FetchSpecialRegisters.php

<?
$sql="
SELECT CURRENT CLIENT_ACCTNG AS ACCOUNTINGSTRINGSPCREG,
    CURRENT CLIENT_APPLNAME AS APPLICATIONNAMESPCREG,
    CURRENT CLIENT_PROGRAMID AS CLIENTPROGRAMIDSPCREG,
    CURRENT CLIENT_USERID AS CLIENTUSERIDSPCREG,
    CURRENT CLIENT_WRKSTNNAME AS WORKSTATIONNAMESPCREG,
    CURRENT_DATE AS CURRENTDATESPCREG,
    CURRENT DEBUG MODE AS DEBUGMODESPCREG,
    CURRENT DECFLOAT ROUNDING MODE AS DECROUNDINGMODESPCREG,
    CURRENT DEGREE AS DEGREEOFIOOFSMPSPCREG,
    CURRENT_PATH AS PATHFORUNQUALIFIEDNAMESSPCREG,
    CURRENT_SCHEMA AS CURRENTSCHEMASPCREG,
    CURRENT_SERVER AS CURRENTSERVERSPCREG,
    CURRENT_TIME AS CURRENTTIMESPCREG,
    CURRENT_TIMESTAMP AS CURRENTTIMESTAMPSPCREG,
    CURRENT_TIMEZONE AS CURRENTTIMEZONESPCREG,
    SESSION_USER  AS SESSIONUSRSPCREG,
    USER AS USERVALUESPCREG,
    SYSTEM_USER AS SYSTEMUSERSPCREG 
FROM SYSIBM.SYSDUMMY1";
$stmt = db2_exec($db2Connection,$sql);
$row = db2_fetch_assoc($stmt) ;
if (!$row) { echo "false - Problem retrieving Special Registers";exit(); }
//display all the special register values 
var_dump($row);