Limitations for ADO applications
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.Refreshmethod 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.