create table

Component Integration Services includes changes to the create table command.

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 SQL Anywhere syntax before being passed to the remote server. Datatype conversions are made for datatypes that are unique to the SAP ASE 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.

See also create table in the Reference Manual: Procedures

Server Class ASEnterprise

Component Integration Services passes the datatype of each column to the remote server without conversion.

Server Class ASAnywhere

Component Integration Services passes the datatype of each column to the remote server without conversion.

Server Class ASIQ

Component Integration Services passes the datatype of each column to the remote server without conversion.

Server Class direct_connect

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.
SAP ASE datatypes are converted to either the DirectConnect syntax mode datatypes shown below.

DirectConnect datatype conversions for create table
SAP ASE 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`