These steps describe how a service library processes a destination-template transfer from statement from Adaptive Server to ODBC.
The access service executes the sourceselectstatement against the primary database and retrieves the schema of the result set.
The access service inserts the first n rows of data (where n is the setting of the TransferBatch property) resulting from the sourceselectstatement into the destination-template. The access service formats the data according to the specified qualifiers and groups the statements into a request.
The access service executes the request against the primary database.
The access service substitutes the next n rows and executes another request. It repeats this process until all the rows finish processing.
If conversion errors occur as rows are inserted, the invalid rows are handled according to the values set in the CharConvertError, NumConvertError, DatetimeConvertError, DefaultDate, DefaultNum, and DefaultTime properties, and the transfer continues. If SendWarningMessages is set to yes, a warning message is sent to the client.
