Delicious Bookmark this on Delicious Share on Facebook SlashdotSlashdot It! Digg! Digg



PHP : Function Reference : IBM DB2, Cloudscape and Apache Derby Functions : db2_server_info

db2_server_info

Returns an object with properties that describe the DB2 database server (PECL ibm_db2:1.1.1-1.6.2)
object db2_server_info ( resource connection )

Example 952. A db2_server_info() example

To retrieve information about the server, you must pass a valid database connection resource to db2_server_info().

<?php

$conn
= db2_connect('sample', 'db2inst1', 'ibmdb2');

$server = db2_server_info( $conn );

if (
$server) {
   echo
"DBMS_NAME: ";                 var_dump( $server->DBMS_NAME );
   echo
"DBMS_VER: ";                  var_dump( $server->DBMS_VER );
   echo
"DB_CODEPAGE: ";               var_dump( $server->DB_CODEPAGE );
   echo
"DB_NAME: ";                   var_dump( $server->DB_NAME );
   echo
"INST_NAME: ";                 var_dump( $server->INST_NAME );
   echo
"SPECIAL_CHARS: ";             var_dump( $server->SPECIAL_CHARS );
   echo
"KEYWORDS: ";                  var_dump( sizeof($server->KEYWORDS) );
   echo
"DFT_ISOLATION: ";             var_dump( $server->DFT_ISOLATION );
   echo
"ISOLATION_OPTION: ";
   
$il = '';
   foreach(
$server->ISOLATION_OPTION as $opt )
   {
     
$il .= $opt." ";
   }
   
var_dump( $il );
   echo
"SQL_CONFORMANCE: ";           var_dump( $server->SQL_CONFORMANCE );
   echo
"PROCEDURES: ";                var_dump( $server->PROCEDURES );
   echo
"IDENTIFIER_QUOTE_CHAR: ";     var_dump( $server->IDENTIFIER_QUOTE_CHAR );
   echo
"LIKE_ESCAPE_CLAUSE: ";        var_dump( $server->LIKE_ESCAPE_CLAUSE );
   echo
"MAX_COL_NAME_LEN: ";          var_dump( $server->MAX_COL_NAME_LEN );
   echo
"MAX_ROW_SIZE: ";              var_dump( $server->MAX_ROW_SIZE );
   echo
"MAX_IDENTIFIER_LEN: ";        var_dump( $server->MAX_IDENTIFIER_LEN );
   echo
"MAX_INDEX_SIZE: ";            var_dump( $server->MAX_INDEX_SIZE );
   echo
"MAX_PROC_NAME_LEN: ";         var_dump( $server->MAX_PROC_NAME_LEN );
   echo
"MAX_SCHEMA_NAME_LEN: ";       var_dump( $server->MAX_SCHEMA_NAME_LEN );
   echo
"MAX_STATEMENT_LEN: ";         var_dump( $server->MAX_STATEMENT_LEN );
   echo
"MAX_TABLE_NAME_LEN: ";        var_dump( $server->MAX_TABLE_NAME_LEN );
   echo
"NON_NULLABLE_COLUMNS: ";      var_dump( $server->NON_NULLABLE_COLUMNS );

   
db2_close($conn);
}
?>

The above example will output:

DBMS_NAME: string(9) "DB2/LINUX"
DBMS_VER: string(10) "08.02.0000"
DB_CODEPAGE: int(1208)
DB_NAME: string(6) "SAMPLE"
INST_NAME: string(8) "db2inst1"
SPECIAL_CHARS: string(2) "@#"
KEYWORDS: int(179)
DFT_ISOLATION: string(2) "CS"
ISOLATION_OPTION: string(12) "UR CS RS RR "
SQL_CONFORMANCE: string(7) "FIPS127"
PROCEDURES: bool(true)
IDENTIFIER_QUOTE_CHAR: string(1) """
LIKE_ESCAPE_CLAUSE: bool(true)
MAX_COL_NAME_LEN: int(30)
MAX_ROW_SIZE: int(32677)
MAX_IDENTIFIER_LEN: int(18)
MAX_INDEX_SIZE: int(1024)
MAX_PROC_NAME_LEN: int(128)
MAX_SCHEMA_NAME_LEN: int(30)
MAX_STATEMENT_LEN: int(2097152)
MAX_TABLE_NAME_LEN: int(128)
NON_NULLABLE_COLUMNS: bool(true)

Change Language


Follow Navioo On Twitter
db2_autocommit
db2_bind_param
db2_client_info
db2_close
db2_column_privileges
db2_columns
db2_commit
db2_conn_error
db2_conn_errormsg
db2_connect
db2_cursor_type
db2_escape_string
db2_exec
db2_execute
db2_fetch_array
db2_fetch_assoc
db2_fetch_both
db2_fetch_object
db2_fetch_row
db2_field_display_size
db2_field_name
db2_field_num
db2_field_precision
db2_field_scale
db2_field_type
db2_field_width
db2_foreign_keys
db2_free_result
db2_free_stmt
db2_get_option
db2_lob_read
db2_next_result
db2_num_fields
db2_num_rows
db2_pconnect
db2_prepare
db2_primary_keys
db2_procedure_columns
db2_procedures
db2_result
db2_rollback
db2_server_info
db2_set_option
db2_special_columns
db2_statistics
db2_stmt_error
db2_stmt_errormsg
db2_table_privileges
db2_tables
eXTReMe Tracker