These steps describe how a service library processes a destination-template transfer to statement to a target from ODBC.
The access service issues the sourceselectstatement against the primary database and receives the schema of the result set.
The access service receives the results of the sourceselectstatement and converts them to the predefined Adaptive Server datatypes. These datatypes do not necessarily match the datatypes of the columns in the destination table.
The access service substitutes the first n rows of the result set (where n is the number of rows specified in the TransferBatch configuration property). The access service formats the data according to the specified datatype qualifiers and batches the statements into a request.
The access service issues the request against the secondary database.
The access service substitutes the next n rows into the destinationtemplatestatement and issues another request against the secondary database. 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.
