Procedure Parameters Schema Rowset - OLE DB Provider for Teradata

Procedure Parameters Schema Rowset

Table 33: Procedure Parameters Schema Rowset

Default Sort Order	Supported Restrictions	Supported Columns
PROCEDURE_SCHEMA PROCEDURE_NAME	PROCEDURE_SCHEMA PROCEDURE_NAME	PROCEDURE_SCHEMA PROCEDURE_NAME PARAMETER_NAME PARAMETER_TYPE IS_NULLABLE DATA_TYPE NUMERIC_PRECISION NUMERIC_SCALE TYPE_NAME CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH

Macros

OLE DB Provider for Teradata also returns information on Teradata Database macros.

Specify Restrictions

If PROCEDURE_SCHEMA is unrestricted, then OLE DB Provider for Teradata returns only parameters of stored procedures/macros from the user’s default database.

If the provider string attribute “Use X Views” is set to YES, and a database name has been specified in PROCEDURE_SCHEMA, then OLE DB Provider for Teradata returns only parameters of those stored procedures/ macros that the user has privilege to access.

If “Use X Views” is set to NO, and a database name has been specified in the PROCEDURE_SCHEMA column, then OLE DB Provider for Teradata can return the parameters of stored procedures/macros from any database.