| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Access Service User's Guide DirectConnect for AS/400 |
![[-]](/dwicons/i_colpse.gif)
| Chapter 12 Accessing catalog information with CSPs |
|
| sp_server_info |
|
| Usage |
If the attribute_id parameter is not provided, sp_server_info returns information about all attributes.
This function does not correspond to any ODBC function, but returns some of the information returned by SQLGetInfo.
sp_server_info returns a list of the requested attributes and their values.
The lengths for varchar columns shown in the result set tables are maximums; the actual lengths depend on the target database.
The following table shows the result set.
Column | Datatype | Description |
ATTRIBUTE_ID | intNOT NULL | Numeric identifier of the attribute |
ATTRIBUTE_NAME | varchar(60) | Attribute name |
ATTRIBUTE_VALUE | varchar(254) | Attribute value |
|
|