Chapter 12: Retrieving Information with System Procedures

sp_sqlgetinfo

Provides information about SQL parameters that the target database supports for the specified attribute.

sp_sqlgetinfo [attribute_name]

attribute_name: is the name of the attribute about which information is requested. Wildcard characters are supported.

If the attribute is not found in the internal table, the DB2 access service returns an empty result set.
If a parameter is not provided, the DB2 access service returns a result set of all supported attributes.
This stored procedure provides SQL grammar, syntax, and capabilities that are supported on the target database.
The DB2 access service stores this information in a file that you can modify if necessary. The SQLInformationFile property specifies the path and file name. For more information, see “SQLInformationFile”.

The following table shows the sp_sqlgetinfo result set.

**Table 12-6: Result set for sp_sqlgetinfo**
Column Name	Datatype	Description
ATTRIBUTE_ID	int not NULL	The numeric identifier for the attribute
ATTRIBUTE_NAME	varchar(30) not NULL	The name of the attribute
ATTRIBUTE_VALUE	varchar(255) NULL	The value of the attribute