Symptom
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 repeat('X',13) into #test from iq_dummy
Read more...
Environment
- IQ15.x all version
- IQ16
- IQ16.0 SP01, SP02, SP03
Product
SAP IQ all versions
Keywords
CAST , REPEAT , , 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 ONE Support launchpad (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.