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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.