Datatype conversions

Datatype conversion can take place whenever the server receives data from a remote source, be it DB2, Adaptive Server, or an Open Server-based application.

Depending on the remote datatype of each column, data is converted from the native datatype on the remote server to a form that the local server supports.

Datatype conversions are made when the create table, alter table and create existing table commands are processed. The datatype conversions are dependent on the remote server’s server class. See the create table, alter table and create existing table commands in the following reference pages for tables that illustrate the datatype conversions that take place for each server class when the commands are processed.