SAP Knowledge Base Article - Preview

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.

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

SAP Adaptive Server Enterprise 15.7

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.