Symptom
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
)
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7
Product
Keywords
proxy table,remote column , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.