Provides information about SQL parameters that the target database supports for the specified attribute.
sp_sqlgetinfo [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”.
Table 12-6 shows the sp_sqlgetinfo result set.
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 |
