SAP Knowledge Base Article - Preview

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>- -- 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 SYBASE ECDA Sybase EnterpriseConnect Data Access (ECDA)
  • DB2 AS400 iSeries
  • DB2 LUW Linux Unix Windows
  • ODBC driver to DB2


SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase EnterpriseConnect Data Access 15.7


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

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.