ADO applications have
limitations with calling stored procedures, inserting a new row by
using a server-side scrollable cursor, and no support for default
parameter values.
The limitations for ADO applications are:
- ADO applications calling stored procedures must have their parameters
created and explicitly bound. The Parameters.Refresh method
for automatically generating parameters is not supported for DB2® Server for VSE &
VM.
- There is no support for default parameter values.
- When inserting a new row using a server-side scrollable cursor,
use the AddNew() method with the Fieldlist and
Values arguments. This is more efficient than calling AddNew() with
no arguments following Update() calls for each
column. Each AddNew() and Update() call
is a separate request to the server and therefore, is less efficient
than a single call to AddNew().
- Newly inserted rows are not updatable with a server-side scrollable
cursor.
- Tables with long or LOB data are not updatable when using a server-side
scrollable cursor.