2208593 - CREATE PROXY_TABLE converts a remote column defined as CHAR(6) NULL via a user-defined datatype to a VARCHAR(6) proxy column in ASE.

The CREATE PROXY_TABLE command converts a CHAR(6) NULL remote column to a VARCHAR(6) proxy column when the remote column is defined with a user-defined datatype (UDT) as follows:

sp_addtype 'day_part_id_type','char(6)','NOT NULL'
go
 
CREATE TABLE dbo.mytable
(
season_id season_id_type NOT NULL,
season char(30) NOT NULL,
start_date datetime NULL,
end_date datetime NULL,
my_season season_id_type NOT NULL,
universe float NOT NULL,
status_code code_type NOT NULL,
excel_no sys_no_type NOT NULL,
next_ratecard_no ratecard_no_type NOT NULL,
next_contract_no contract_no_type NOT NULL,
day_part_id day_part_id_type NULL,
user_community_type tinyint NULL,
next_deal_no int DEFAULT 1 NOT NULL,
rating_type_code smallint NULL,
rating_stream_code smallint NULL
)

SAP Adaptive Server Enterprise (ASE) 15.7

proxy table,remote column , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem