Simple PHP script to pull SQL Special Register values from the IBM DB2 via the commandline QP2TERM

test.php

<?php
// Call this script in pase using:
// Call QP2TERM
// /usr/local/zendsvr/bin/php-cli /www/zendsvr/htdocs/test.php
 
// This script will use the current user thats logged in and the default database.
// Note: We can't use $_SERVER['APP_ENV'] because PHP-CLI doesn't get that value.
// That value is set by Apache on web requests
 
$db2Connection = db2_connect( '', '' , '',array());
if (!$db2Connection) { echo "false - Connection failed";exit(); }
 
//$sql = "SELECT CURRENT_SERVER AS SERVER, SESSION_USER AS USER " .
// "FROM SYSIBM.SYSDUMMY1";
$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 via PHP CLI";exit(); }
 
//display all the special register values to command line. use page up and page down to view.
var_dump($row);
exit(0);
?>