SAP Knowledge Base Article - Preview

2876571 - SAP IQ - "unknown datatype" error during adding spatial columns

Symptom

During creating a table having "ST_POINT" data type, "unknown datatype" error occurs like below.

CREATE TABLE test (ID INT PRIMARY KEY, stPoint ST_Point)

or

CREATE TABLE test (ID INT PRIMARY KEY, stPoint ST_Point) IN IQ_SYSTEM_MAIN;

Column '2' has an unknown datatype: 'Unknown TypeID (40)'.
(dblib\db_catalog.cxx 2310)
SQLCODE=-1000057, ODBC 3 State="HY000"


Read more...

Environment

  • SAP IQ 16.x

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

"ST_POINT"; , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , How To

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.