Home

	Expand Search

Access Service User's Guide DirectConnect for AS/400

Chapter 10 Using Bulk Copy Transfer

Datatype conversion for transfer from statements

Datatype conversion for transfer from statements

Use transfer from when you want to transfer data from a secondary database, either Adaptive Server or another database through another access service, to the primary database. The primary database, the AS/400, is the target and is implied in the transfer statement; the secondary and source database is specified in the transfer statement.

The following figure shows the data flow of one of the preceding transfer from examples, which transfers data from sstable3 in Adaptive Server to replace data in the AS/400 table named as4table1.

The access service performs datatype conversions for bulk copy transfer from statements. These conversions are defined within the access service and are not affected by the settings of the datatype conversion configuration properties. The access service converts these datatypes into the actual datatypes of the target columns. If the access service cannot convert the columns, an error occurs. For information about errors, see "Transfer errors and error handling" and "Errors from data values" .

The following table shows the acceptable Open Server datatypes that the access service can convert into corresponding AS/400 datatypes. To save space, the CS_ prefix is removed from Open Server datatypes, and similar AS/400 datatypes are combined.