/**
* {@inheritDoc}
*/
public function getCurrentSchema()
{
if (!$this->isConnected()) {
$this->connect();
}
$info = db2_server_info($this->resource);
return isset($info->DB_NAME) ? $info->DB_NAME : '';
}
/**
* @return string
*/
public function getQuoteIdentifierSymbol()
{
$this->_connect();
$info = db2_server_info($this->_connection);
$identQuote = $info->IDENTIFIER_QUOTE_CHAR;
return $identQuote;
}
/**
* Retrieve server version in PHP style
*
* @return string
*/
public function getServerVersion()
{
$this->_connect();
$server_info = db2_server_info($this->_connection);
if ($server_info !== false) {
$version = $server_info->DBMS_VER;
if ($this->_isI5) {
$version = (int) substr($version, 0, 2) . '.' . (int) substr($version, 2, 2) . '.' . (int) substr($version, 4);
}
return $version;
} else {
return null;
}
}
/**
* @return string Version information from the database
*/
public function getServerVersion()
{
$info = db2_server_info($this->mConn);
return $info->DBMS_VER;
}
/**
* Quotes an identifier.
*
* @param string $ident The identifier.
*
* @return string The quoted identifier.
*/
public function quoteIdentifier($string)
{
$info = db2_server_info($this->_connection);
$identQuote = $info->IDENTIFIER_QUOTE_CHAR;
return $identQuote . $string . $identQuote;
}
public function getDbInfo()
{
$this->getDatabase();
$server = @db2_server_info($this->database);
if (is_object($server)) {
$server = get_object_vars($server);
} else {
$server = null;
}
$client = @db2_client_info($this->database);
if (is_object($client)) {
$client = get_object_vars($client);
} else {
$client = null;
}
return array("IBM DB2 Client Info" => $client, "IBM DB2 Server Info" => $server);
}
public function getSchema()
{
$server = db2_server_info($this->_db->getConnection());
return $server->DB_NAME;
}
/**
* This function returns the version string.
*
* @access public
* @author Thorsten Rinne <*****@*****.**>
* @since 2005-04-16
*/
function server_version()
{
$server = db2_server_info($this->conn);
$ver = $server->DBMS_NAME . ' ' . $server->DBMS_VER;
return $ver;
}
public static function getPrimaryKey($table, $conn, $dbtype)
{
/**
* Discover metadata information about this table.
*/
$server_info = db2_server_info($conn);
// $server_info->DBMS_NAME == "QSQ" is iSeries / i5
if ($server_info->DBMS_NAME == "QSQ") {
$sql = "SELECT column_name as colname FROM qsys2.syskeycst ";
$sql .= "WHERE system_table_name = '" . $table . "' and ordinal_position > 0 order by ordinal_position asc";
} else {
$sql = "SELECT colname FROM SYSCAT.COLUMNS WHERE TABNAME = '" . $table . "' AND KEYSEQ > 0 ORDER BY KEYSEQ ASC";
}
$rs = self::query($conn, $sql);
if ($rs) {
$res = self::fetch_num($rs);
self::closeCursor($rs);
if ($res) {
return $res[0];
}
}
return false;
}
