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
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.