SAP Knowledge Base Article - Preview

1965517 - A SQL without LOB DataType hits an error : "Large Objects Management functionality is not licensed on this server" -- SAP IQ

Symptom

Though there is no columns with LOB datatypes, when the query includes some functions like below  in "Select.... INTO ... from", error such as "Large Objects Management functionality is not licensed on this server" must have.

  • AES_ENCRYPT()
  • CONVERT()
  • GRAPHICAL_PLAN()
  • HTML_DECODE() 
  • HTML_ENCODE() 
  • HTTP_HEADER()
  • INSERTSTR()
  • LCASE()
  • LEFT()
  • LIST()
  • LOWER()
  • LTRIM()
  • NEXT_HTTP_VARIABLE()
  • REPEAT()
  • REPLACE()
  • REVERSE()
  • RIGHT()
  • RTRIM()
  • SPACE()
  • SQLFLAGGER()
  • STRING()
  • SUBSTRING()
  • SUSER_NAME()
  • TRIM()
  • UCASE()
  • UPPER()
  • USER_NAME()

Example)  Select REVERSE('06 MAR 15')  COL1, 1 COL2 INTO mytab  From iq_dummy ; 

Error =>

     Could not execute statement.
     Large Objects Management functionality is not licensed on this server.
     -- (dblib/db_catalog.cxx 7021)
     SQLCODE=-1003007, ODBC 3 State="HY000"


Read more...

Environment

  • IQ15.x all version
  • IQ16
  • IQ16.0  SP01, SP02, SP03

Product

SAP IQ all versions

Keywords

IQ_LOB, Unstructured Data Analytics, UDA, LOB, Large object, Long Varchar, Long Binary, , KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement

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.