Component Integration Services passes the datatype of each column to the remote server without conversion.
Component Integration Services passes the datatype of each column to the remote server without conversion.
Component Integration Services passes the datatype of each column to the remote server without conversion.
Component Integration Services reconstructs create table and passes commands to the targeted DirectConnect. The gateway transforms the commands into a form that the underlying DBMS recognizes.
Direct Connect does not support bigint, unsigned tinyint, unsigned smallint, unsigned int, unsigned bigint.
Adaptive Server datatypes are converted to either the DirectConnect syntax mode datatypes shown in Table 3-14.
Adaptive Server datatype |
DirectConnect default datatype |
---|---|
binary(n) |
binary(n) |
bit |
bit |
char |
char |
datetime |
datetime |
decimal(p, s) |
decimal(p, s) |
float |
float |
image |
image |
int |
int |
money |
money |
numeric(p, s) |
numeric(p, s) |
nchar(n) |
nchar(n) |
nvarchar(n) |
nvarchar(n) |
real |
real |
smalldatetime |
smalldatetime |
smallint |
smallint |
smallmoney |
smallmoney |
timestamp |
timestamp |
tinyint |
tinyint |
text |
text |
unichar(n) |
unichar |
univarchar(n) |
char(n) for bit data |
varbinary(n) |
varbinary(n) |
varchar(n) |
varchar(n) |
date |
|
time |
|
bigint |
UDB and DC/Microsoft support bigint |
When the server receives a create table command, the command is interpreted as a request for new table creation. The server invokes the access method appropriate for the server class of the table that is to be created. If it is remote, the table is created. If this command is successful, system catalogs are updated, and the object appears to clients as a local table in the database in which it was created.
create table is reconstructed in a syntax that is appropriate if the server class. For example, if the server class is direct_connect and the remote server is DB2, the command is reconstructed using Adaptive Server Anywhere syntax before being passed to the remote server. Datatype conversions are made for datatypes that are unique to the Adaptive Server environment.
Some server classes have restrictions on what datatypes can and cannot be supported.
create table is passed to remote servers as a language request.
create table in the Reference Manual