<?php
function menu_connect($database='MYDB', $hostname='localhost', $port=1527, $user='lynn', $password='5tuff') {
// Create the uncataloged connection string
$DSN = "DRIVER={IBM DB2 ODBC DRIVER};PROTOCOL=TCPIP;"
. "DATABASE=$database;HOSTNAME=$hostname;PORT=$port;"
. "UID=$user;PWD=$password;";
$dbh = new PDO("odbc:$DSN");
return $dbh;
}
?>
<?php
// include the menu_lib.php file within this script
require_once('menu_lib.php');
// Create the connection, catching any exceptions
try {
// connect with default parameter values
$conn = menu_connect();
}
catch (PDOException $e) {
print "Failed to connect: " . $e->getMessage();
exit;
}
// Here is where we would do real work; just print connection status
print "Connection succeeded!";
// Clean up the connection
$conn = null;
?>
bash$ . /home/db2inst1/sqllib/db2profile