Recordset Methods
The following table lists the Recordset Methods and shows whether client-side and server-side cursors support the methods. The Restrictions column shows any restrictions that affect the methods.
Method |
Supported |
Restrictions |
|
Client-Side |
Server-Side |
||
AddNew |
Yes |
Yes |
|
Cancel |
Yes |
Yes |
|
CancelBatch |
Yes |
Yes |
|
CancelUpdate |
Yes |
Yes |
|
Clone |
No |
No |
|
Close |
Yes |
Yes |
|
Delete |
Yes |
Yes |
Client Side Cursors restriction: Rows in a recordset that contains TIME or TIMESTAMP columns can only be modified using the Update and Delete methods under the following conditions: If the consumer does not meet these conditions, and the consumer attempts to Update or Delete a row in a recordset that contains a TIME or TIMESTAMP column, the following error message is generated by Teradata Database: [Teradata Database]Invalid operation on an ANSI Datetime or Interval value.
Server-Side Cursors do not have this restriction. |
Find |
Yes |
No |
Server-Side Cursors: Although the Supports method indicates that Find is supported, OLE DB Provider for Teradata does not support the Find method. |
GetRows |
Yes |
Yes |
Server-Side Cursors Restriction: Rows can only be retrieved starting from the current position. |
Move |
Yes |
Yes |
Server-Side Cursors Restrictions: |
MoveFirst |
Yes |
Yes |
|
MoveLast |
Yes |
No |
|
MoveNext |
Yes |
Yes |
|
MovePrevious |
Yes |
No |
|
NextRecordset |
Yes |
Yes |
|
Notifications |
Yes |
Yes |
|
Open |
Yes |
Yes |
|
Requery |
Yes |
Yes |
|
Resync |
Yes |
Yes |
|
Seek |
No |
No |
|
Supports |
Yes |
Yes |
|
Update |
Yes |
Yes |
See restrictions for the Delete method. |
UpdateBatch |
Yes |
Yes |
See restrictions for the Delete method. |