
If it is set to False, then only one row will be fetched at a time. If it is set to True, the provider will fetch a block of records from the database when an application is scrolling through a result set. The block fetch property is a Boolean value that determines the provider fetch behavior when the ADO cache size is set to 1. Note: This property only applies to database host server jobs (QZDASOINIT or QZDASSINIT). The default value is the name of the EXE running the current application. Setting this value updates the DB2 for i5/OS SQL CLIENT_APPLNAME special register value. Specifies the application name for the connection. If it is set to False, the provider will use the existing statements in the package, but will not add any new statements to the package. If it is set to True, new statements will be added to the SQL package. The add statements property is a Boolean value used to indicate how SQL packages should be used when package support is enabled. For more information about any of these properties, consult the IBM i Access for Windows OLE DB Technical Reference which can be found in the Programmer's Toolkit included with IBM Access Client Solutions - Windows Application Package.

The release at which each property was added is indicated.

The following list contains all of the custom properties that are available for the OLE DB providers shipped with IBM Access Client Solutions - Windows Application Package (IBMDA400, IBMDARLA, and IBMDASQL).
