<?php
$database = 'XYZ';
$user = 'vXXX';
$password = 'QQQQQ';
$conn = db2_connect($database, $user, $password);
if ($conn) {
echo "Connection succeeded.";
$query="select {fn timestampadd(SQL_TSI_SECOND,30,end1)} from request";
$result = db2_prepare($conn, $query);
if ($result) {
<?php
$database = 'VCL';
$user = 'vcluser';
$password = 'vcluserpassword';
$conn = db2_connect($database, $user, $password);
if ($conn) {
echo "Connection succeeded.";
db2_close($conn);
}
else {
echo "Connection failed.";
<?php
// Create the uncataloged connection string
$DSN = "DRIVER={IBM DB2 ODBC DRIVER};PROTOCOL=TCPIP;"
. "DATABASE='TEST';HOSTNAME='localhost';PORT=1527;"
Leave a comment: