2443015 - ASE create proxy table to DB2 error SQL0913N Column type mismatch in remote object - ECDA

• Creating proxy table in SAP Adaptive Server Enterprise (ASE) through ECDA to DB2 using one of the following ddl syntax options fails:
     1) create existing table <table_name>(c1_name <data_type> <options>, . . . c[n]_name <data_type> <options>) EXTERNAL TABLE AT "<server>.<database>.<owner>.<tablename>"
     2) create proxy_table <table_name>at "<server>.<database>.<owner>.<tablename>"
  
  
• Fails creating proxy table correctly
     Creates proxy table with column data type promoted to text when column preferred to be char(n) varchar(n) instead
  
  
• Fails with an error associated with [DB2 AS400] SQL0913N
     Example of error with [DB2 AS400]:
        13:34:52.902 DBMS <ase_server_name>-10.10.20.34 -- Number (30291) Severity (19) State (0) Server (<ecda_server/service_name>) 
              [[Message Iteration=1|Data Source Name=<dsn_name>|SQL Function=ALTER TABLE|SQLState=60|Native Error=-913|Message=[DataDirect]
              [ODBC 20101 driver][UDB DB2 for iSeries and AS/400]8227] ( )
  
  
• Fails with an error associated with [DB2 LUW]    Column type mismatch in remote object
     Example of error with [DB2 LUW]:
              Msg 11209, Level 16, State 1:
              Server 'pds', Line 1:
              Column type mismatch in remote object 'SAPX6D.' for column 'C2_VARCHAR2K'; (defined: 39 found: 35)

• SAP ADAPTIVE SERVER ENTERPRISE (ASE)
• SAP SYBASE ASE
• SAP SYBASE ECDA Sybase EnterpriseConnect Data Access (ECDA)
• DB2 AS400 iSeries
• DB2 LUW Linux Unix Windows
• ODBC driver to DB2

SAP Adaptive Server Enterprise ASE DB2 create existing table EXTERNAL proxy_table proxy table DB2 AS400 SQL0913N DB2 LUW column type mismatch in remote object
promoted to text Number (30291) Severity (19) State (0) ALTER TABLE SQLState=60 Native Error=-913 UDB DB2 for iSeries and AS/400 Msg 11209  Level 16  State 1 (defined: 39 found: 35) , KBA , BC-SYB-ECD , Enterprise Connect (ECDA) , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem