Returns a list of SAP ASE attribute names and current values.
sp_server_info [attribute_id]
sp_server_info 12
attribute_id attribute_name attribute_value ------------ ------------------------- -------------------------- 12 MAX_OWNER_NAME_LENGTH 0
sp_server_info
The results set for sp_server_info is:
Column |
Datatype |
Description |
|---|---|---|
attribute_id |
int |
NOT NULL. |
attribute_name |
varchar(60) |
NOT NULL. |
attribute_value |
varchar(255) |
The mandatory rows in the results set returned by sp_server_info are:
ID |
Server Attribute Name |
Description |
Value |
|---|---|---|---|
1 |
DBMS_NAME |
Name of the DBMS. |
SQL SERVER |
2 |
DBMS_VER |
The value used by the ODBC driver to determine version compatibility. Note: Do not change the value of DBMS_VER.
This is not the same as @@version,
and the value must match the value used by the ODBC driver.
|
Actual value |
6 |
DBE_NAME |
Unused |
|
10 |
OWNER_TERM |
SAP ASE server’s term for a table owner (the second part of a three-part name). |
owner |
11 |
TABLE_TERM |
SAP ASE server’s term for a table (the third part of a three-part name). |
table |
12 |
MAX_OWNER_NAME_LENGTH |
Maximum length of the name for a table owner (the second part of a three-part name). |
30 |
13 |
TABLE_LENGTH |
The maximum number of characters for a table name. |
30 |
14 |
MAX_QUAL_LENGTH |
Maximum length of the name for a table qualifier (the first part of a three-part table name). |
30 |
15 |
COLUMN_LENGTH |
The maximum number of characters for a column name. |
30 |
16 |
IDENTIFIER_CASE |
The case sensitivity of user-defined names (table names, column names, and stored procedure names) in the database (the case in which these objects are presented in the system catalogs). |
MIXED |
18 |
COLLATION_SEQ |
The assumed ordering of the character set for this server. |
|
19 |
SAVEPOINT_SUPPORT |
Does the underlying DBMS support named savepoints? |
Y |
20 |
MULTI_RESULT_SETS |
Does the underlying DBMS or the gateway itself support multiple results sets (can multiple statements be sent through the gateway, with multiple results sets returned to the client)? |
Y |
22 |
ACCESSIBLE_TABLES |
In sp_tables, does the gateway return only tables, views, and so on, that are accessible by the current user (that is, the user who has at least select privileges for the table)? |
Y |
100 |
USERID_LENGTH |
The maximum number of characters for a user name. |
30 |
101 |
QUALIFIER_TERM |
SAP ASE server’s term for a table qualifier (the first part of a three-part name). |
database |
102 |
NAMED_TRANSACTIONS |
Does the underlying DBMS support named transactions? |
Y |
103 |
SPROC_AS_LANGUAGE |
Can stored procedures be executed as language events? |
Y |
103 |
REMOTE_SPROC |
Can stored procedures be executed through the remote stored procedure APIs in DB-Library? |
Y |
104 |
ACCESSIBLE_SPROC |
In sp_stored_procedures, does the gateway return only stored procedures that are executable by the current user? |
Y |
105 |
MAX_INDEX_COLS |
Maximum number of columns in an index for the DBMS. |
32 |
106 |
RENAME_TABLE |
Can tables be renamed? |
Y |
107 |
RENAME_COLUMN |
Can columns be renamed? |
Y |
108 |
DROP_COLUMN |
Can columns be dropped? |
Y |
109 |
INCREASE_COLUMN_LENGTH |
Can column size be increased? |
N |
110 |
DDL_IN_TRANSACTION |
Can DDL statements appear in transactions? |
Y |
111 |
DESCENDING_INDEXES |
Are descending indexes supported? |
Y |
112 |
SP_RENAME |
Can a stored procedure be renamed? |
Y |
500 |
SYS_SPROC_VERSION |
The version of the catalog stored procedures currently implemented. |
01.01.2822 |
Any user can execute sp_server_info.