Access Service User's Guide DirectConnect for AS/400

Description

Returns a list of attribute names and matching values for the target DBMS.

sp_server_info [attribute_id]

attribute_id

is the integer ID of the attribute. Wildcard-character search patterns are not supported.

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.

Results

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.

Result set for *sp_server_info*
Column	Datatype	Description
ATTRIBUTE_ID	intNOT NULL	Numeric identifier of the attribute
ATTRIBUTE_NAME	varchar(60)	Attribute name
ATTRIBUTE_VALUE	varchar(254)	Attribute value


	Expand Search