|
|
SQL1325N error
|
|
DB2_SERVER_INFO(3) 1 DB2_SERVER_INFO(3) db2_server_info - Returns an object with properties that describe the DB2 database server SYNOPSIS
object db2_server_info (resource $connection) DESCRIPTION
This function returns an object with read-only properties that return information about the IBM DB2, Cloudscape, or Apache Derby database server. The following table lists the database server properties: Database server properties +----------------------+--------------------------------------+---+ | Property name | | | | | | | | | Return type | | | | | | | | Description | | | | | | +----------------------+--------------------------------------+---+ | DBMS_NAME | | | | | | | | | string | | | | | | | | The name of the database server to | | | | which you are connected. For DB2 | | | | servers this is a combination of DB2 | | | | followed by the operating system on | | | | which the database server is run- | | | | ning. | | | | | | | DBMS_VER | | | | | | | | | string | | | | | | | | The version of the database server, | | | | in the form of a string "MM.mm.uuuu" | | | | where $MM is the major version, $mm | | | | is the minor version, and $uuuu is | | | | the update. For example, | | | | "08.02.0001" represents major ver- | | | | sion 8, minor version 2, update 1. | | | | | | | DB_CODEPAGE | | | | | | | | | int | | | | | | | | The code page of the database to | | | | which you are connected. | | | | | | | DB_NAME | | | | | | | | | string | | | | | | | | The name of the database to which | | | | you are connected. | | | | | | | DFT_ISOLATION | | | | | | | | | string | | | | | | | | The default transaction isolation | | | | level supported by the server: | | | | | | | | o UR | | | | - Uncommitted read: | | | | changes are immedi- | | | | ately visible by all | | | | concurrent transac- | | | | tions. | | | | | | | | o CS | | | | - Cursor stability: | | | | a row read by one | | | | transaction can be | | | | altered and commit- | | | | ted by a second con- | | | | current transaction. | | | | | | | | o RS | | | | - Read stability: a | | | | transaction can add | | | | or remove rows | | | | matching a search | | | | condition or a pend- | | | | ing transaction. | | | | | | | | o RR | | | | - Repeatable read: | | | | data affected by | | | | pending transaction | | | | is not available to | | | | other transactions. | | | | | | | | o NC | | | | - No commit: any | | | | changes are visible | | | | at the end of a suc- | | | | cessful operation. | | | | Explicit commits and | | | | rollbacks are not | | | | allowed. | | | | | | |IDENTIFIER_QUOTE_CHAR | | | | | | | | | string | | | | | | | | The character used to delimit an | | | | identifier. | | | | | | | INST_NAME | | | | | | | | | string | | | | | | | | The instance on the database server | | | | that contains the database. | | | | | | | ISOLATION_OPTION | | | | | | | | | array | | | | | | | | An array of the isolation options | | | | supported by the database server. | | | | The isolation options are described | | | | in the DFT_ISOLATION property. | | | | | | | KEYWORDS | | | | | | | | | array | | | | | | | | An array of the keywords reserved by | | | | the database server. | | | | | | | LIKE_ESCAPE_CLAUSE | | | | | | | | | bool | | | | | | | | | | | | TRUE if the database server supports | | | | the use of % and _ wildcard charac- | | | | ters. FALSE if the database server | | | | does not support these wildcard | | | | characters. | | | | | | | MAX_COL_NAME_LEN | | | | | | | | | int | | | | | | | | Maximum length of a column name sup- | | | | ported by the database server, | | | | expressed in bytes. | | | | | | | MAX_IDENTIFIER_LEN | | | | | | | | | int | | | | | | | | Maximum length of an SQL identifier | | | | supported by the database server, | | | | expressed in characters. | | | | | | | MAX_INDEX_SIZE | | | | | | | | | int | | | | | | | | Maximum size of columns combined in | | | | an index supported by the database | | | | server, expressed in bytes. | | | | | | | MAX_PROC_NAME_LEN | | | | | | | | | int | | | | | | | | Maximum length of a procedure name | | | | supported by the database server, | | | | expressed in bytes. | | | | | | | MAX_ROW_SIZE | | | | | | | | | int | | | | | | | | Maximum length of a row in a base | | | | table supported by the database | | | | server, expressed in bytes. | | | | | | | MAX_SCHEMA_NAME_LEN | | | | | | | | | int | | | | | | | | Maximum length of a schema name sup- | | | | ported by the database server, | | | | expressed in bytes. | | | | | | | MAX_STATEMENT_LEN | | | | | | | | | int | | | | | | | | Maximum length of an SQL statement | | | | supported by the database server, | | | | expressed in bytes. | | | | | | | MAX_TABLE_NAME_LEN | | | | | | | | | int | | | | | | | | Maximum length of a table name sup- | | | | ported by the database server, | | | | expressed in bytes. | | | | | | |NON_NULLABLE_COLUMNS | | | | | | | | | bool | | | | | | | | | | | | TRUE if the database server supports | | | | columns that can be defined as NOT | | | | NULL, FALSE if the database server | | | | does not support columns defined as | | | | NOT NULL. | | | | | | | PROCEDURES | | | | | | | | | bool | | | | | | | | | | | | TRUE if the database server supports | | | | the use of the CALL statement to | | | | call stored procedures, FALSE if the | | | | database server does not support the | | | | CALL statement. | | | | | | | SPECIAL_CHARS | | | | | | | | | string | | | | | | | | A string containing all of the char- | | | | acters other than a-Z, 0-9, and | | | | underscore that can be used in an | | | | identifier name. | | | | | | | SQL_CONFORMANCE | | | | | | | | | string | | | | | | | | The level of conformance to the | | | | ANSI/ISO SQL-92 specification | | | | offered by the database server: | | | | | | | | o ENTRY | | | | - Entry-level SQL-92 | | | | compliance. | | | | | | | | o FIPS127 | | | | - FIPS-127-2 transi- | | | | tional compliance. | | | | | | | | o FULL | | | | - Full level SQL-92 | | | | compliance. | | | | | | | | o INTERMEDIATE | | | | - Intermediate level | | | | SQL-92 compliance. | | | | | | +----------------------+--------------------------------------+---+ PARAMETERS
o $connection - Specifies an active DB2 client connection. RETURN VALUES
Returns an object on a successful call. Returns FALSE on failure. EXAMPLES
Example #1 A db2_server_info(3) example To retrieve information about the server, you must pass a valid database connection resource to db2_server_info(3). <?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) SEE ALSO
db2_client_info(3). PHP Documentation Group DB2_SERVER_INFO(3)
