Programming Considerations
SQL statements that contain parameters cannot be restarted.
If a statement that contains parameters has been executed, and the consumer calls RestartPosition, then OLE DB Provider for Teradata returns a DB_E_CANNOTRESTART error.
The provider does not support scrolling backwards. In other words, for the GetNextRows method, a negative value cannot be specified for either the offset (lRowOffset), or the number of rows to fetch parameter (crows).
If columns of an underlying table have changed, then any consumers that have rowsets based on this table have to release all accessors, all row handles, and the rowset.
Next, the consumers must execute again the command used to create the rowset.
If this is not done, and a consumer calls IRowset::RestartPosition on the rowset, then OLE DB Provider for Teradata returns the E_FAIL error code.
When this error occurs, OLE DB Provider for Teradata invalidates the rowset and allows consumers to call only:
Calls to other methods fail.