SAP Knowledge Base Article - Preview

3631437 - Error invalid remote object name when creating virtual table in SAP HANA smart data integration

Symptom

  • Cannot create VT from DB2 system.
  • Error message: Failed to query CCSID and FOREIGNKEY from system table SYSIBM.SYSCOLUMNS for tbcreator [***] and tbname [***] and column name [***]. Context: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SYSIBM.SYSCOLUMNS;TABLE, DRIVER=4.27.25 com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SYSIBM.SYSCOLUMNS;TABLE, DRIVER=4.27.25


Read more...

Environment

SAP HANA smart data integration (SDI)

Product

SAP HANA smart data integration 2.0

Keywords

invalid remote object name, SAP HANA smart data integration, DB2MainframeAdapter, SYSIBM.SYSCOLUMNS, SQLCODE=-204, SQLSTATE=42704, virtual table creation, sys_type_as400, DPAgent restart, AS/400 system , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , 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.