SAP Knowledge Base Article - Preview

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

Symptom

  • 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)

Read more...

Environment

  • 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

Product

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

Keywords

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

Search for additional results

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