Procedures Schema Rowset - OLE DB Provider for Teradata

Procedures Schema Rowset

Table 34: Procedures Schema Rowset

Default Sort Order	Supported Restrictions	Supported Columns
PROCEDURE_SCHEMA PROCEDURE_NAME	PROCEDURE_SCHEMA PROCEDURE_NAME	PROCEDURE_SCHEMA PROCEDURE_NAME PROCEDURE_TYPE DATE_CREATED DATE_MODIFIED

Use X Views Limitation

Unlike the Procedure Parameters rowset, the provider string attribute Use X Views has no effect on the Procedure rowset. This will be fixed in a later version, so that the Procedure rowset behavior will be similar to the Procedure Parameters rowset behavior for Use X Views.

Because the settings of the provider string attribute Use X Views has no effect, OLE DB Provider for Teradata has the following behavior when using the supported restrictions:

If PROCEDURE_SCHEMA is unrestricted, then TDOELDB returns only stored procedures and macros from the user’s default database.

If the consumer specifies a database in PROCEDURE_SCHEMA, and the user does not have privileges to access the database, then IDBSchemaRowset returns S_OK. However, no rows are returned.

Search Multiple Databases Limitation

A procedure name cannot be searched across multiple databases. For example:

If the PROCEDURE_SCHEMA is null, and a name is entered in the PROCEDURE_NAME column, then only the default database is searched.

Macros

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